Forum Discussion
Conditional formatting assistance please
How do I highlight a cell yellow if the date is 30 days out? How do I highlight a cell red if the date is today or passed? How do I leave a cell alone if there is no date in the cell? All 3 rules ...
You may use with formulas
red
=A1>=TODAY()
yellow
=(TODAY()-A1)<30the rest won't be formatted
SergeiBaklan Thank you Sergei. Please see attached. It doesn't seem like the red formula worked unless i did it wrong. Please advise.
Sorry, it shall be the opposite
=TODAY()>=$G$19to check if the date in the cell is in the past
- Thank you again. However, now the cell will remain remain even with no data.