Conditional formatting assistance please

Question

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 would be for 1 cell.

Thanks in advance!

sergeibaklan · Answer

c_frndz&nbsp;
You may use with formulas
red
=A1&gt;=TODAY()

yellow
=(TODAY()-A1)&lt;30
the rest won't be formatted

c_frndz · Answer

SergeiBaklan&nbsp;Thank you Sergei. Please see attached. It doesn't seem like the red formula worked unless i did it wrong. Please advise.

sergeibaklan · Answer

c_frndz&nbsp;
Sorry, it shall be the opposite
=TODAY()&gt;=$G$19
to check if the date in the cell is in the past

c_frndz · Answer

Thank you again. However, now the cell will remain remain even with no data.

sergeibaklan · Answer

c_frndz&nbsp;
Forgot about blanks
=(TODAY()&gt;=$G$19)*($G$19&gt;1)

Forum Discussion