Forum Discussion
Conditional Foratting by date
I would like every cell that contains a date before today to change colour. I've used: Conditional Formatting / Highlight Cells Rules / Less Than / =TODAY() / specify colour but all cells ar...
You can try this if the "applies to" range is for example A1:F10:
Conditional Formatting / New Rule / Use a formula to determine which cells to format / Format values where this formula is true / =AND(A1<>"",A1<TODAY())
If the "applies to" range is E20:R40 then you can try this formula for conditional formatting:
=AND(E20<>"",E20<TODAY())
OliverScheurichthank you - wow that was quick! Unfortunately it didn't work for me but thank you very much for trying.
