Forum Discussion
Conditional formula
Hi, I have been trying to work out a formula in a conditional formatting. The formula is to highlight a cell in the two columns which the date is overdue (less than today's date) ,meanwhile not to...
Select cell A1 (being A1 a cell you want to apply the conditional formatting). Go to the Home tab of the ribbon > Conditional Formatting > New rule > "Use a formula to determine which cells to format". Then, type this:
=AND($A1<TODAY(),NOT(ISBLANK($A1)))
And select to fill with red color.
You can then click on the Format Painter on the left side of the Home tab of the ribbon and then copy format to all cells that you want to apply the same conditional formatting.
Thank you very much Martin.
I tried your formula, it seems not work for both condition.
However, I changed a little bit and it worked for my question.
=AND($A1<TODAY(),NOT(ISBLANK($A1)))
Very much appreciated!
I tried your formula, it seems not work for both condition.
However, I changed a little bit and it worked for my question.
=AND($A1<TODAY(),NOT(ISBLANK($A1)))
Very much appreciated!
So glad it finally worked then! "Blank" cells can be tricky sometimes. Editing my first reply in case you may consider marking the post as solved. Thanks!