Forum Discussion
Conditional Formatting based on referenced cell with a date
I have a spreadsheet to track orders placed and the PO's for each order. I want to highlight column B if the order hasn't been Rcv'd yet, so I created a conditional format formula of =IF($A$2:$A$4000,"") which applies to =$C:$C. Seems to work fine. But how do I write a conditional format formula to automatically remove the highlight from the cell in Column C, once I've entered a rec'd date in Column A? I'm thinking maybe just need a second format formula, but I don't know how to write it. Can anyone help on this? I'm a novice w/formulas.
4 Replies
The formula for the conditional formatting rule should be
=$A2=""
and it should apply to C2:C4000 (for example).
Thank you. But that will give me formatting for the cell if it is empty. What would be the formula to format the cell a different color (or no color) when I enter a date or txt into the cell?
The easiest way is to set the fill color of the cells directly. That color will be used when the conditional formatting rule is not applied, i.e. if column A is not empty.
