Forum Discussion
c_frndz
Feb 17, 2020Copper Contributor
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 ...
SergeiBaklan
Feb 17, 2020Diamond Contributor
You may use with formulas
red
=A1>=TODAY()
yellow
=(TODAY()-A1)<30
the rest won't be formatted
c_frndz
Feb 17, 2020Copper Contributor
SergeiBaklan Thank you Sergei. Please see attached. It doesn't seem like the red formula worked unless i did it wrong. Please advise.
- SergeiBaklanFeb 17, 2020Diamond Contributor
Sorry, it shall be the opposite
=TODAY()>=$G$19to check if the date in the cell is in the past
- c_frndzFeb 17, 2020Copper ContributorThank you again. However, now the cell will remain remain even with no data.
- SergeiBaklanFeb 18, 2020Diamond Contributor