Conditional formatting with formulas
I am trying to create a spreadsheet to track ordered parts and their status, including their requested delivery date.
What I'm trying to sort out, and failing at, is setting a conditional format so that when the requested delivery date is less than X days out (say 14 for now), I want it to highlight the cell red so I can check on the status of the order.
This is my current rule configuration, which I set by selecting the column so it auto populates as it's filled in.
Inconveniently, it's doing the exact opposite of what I want:
In this instance, ONLY 4/13 should be highlighted (I'm not worried about the top row at this point, I'll fix that after).
I've even tried creating another column to do the math, and use that cell for the formula, and that's not working either. It seems like it should be straight forward, but I apparently lack the formatting skill.
[link] [comments]
Want to read more?
Check out the full article on the original site