Forum Discussion
Conditional formatting where one date is greater than another date
Hello you lovely people. I am trying to add conditional formatting to a spreadsheet. Excel 2013 In column F i have a date required, then in column H i have a date expected. I want to highligh...
You can use more than 1 rule to the conditional formatting; add one rule that leaves colorless any empty cell.
Thank you Arul. I tried that as the first rule. It was "format any cell that contains" blank cell.
But the whole of column H formats.
Maybe i need to start from scratch?
I used the embedded conditions.
Conditional formatting>Highlight Cells Rules>Greater Than.
I then added the other rule for blank cells.
In both cases i had the whole of column H selected to ensure it was not an absolute reference in the formula.
Sometimes I apply the formatting to only 1 cell, then I edit the rules removing $ from the reference, then I copypaste the cell. It should work...
