Forum Discussion

Copper Contributor

Feb 17, 2020

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 ...

excel

c_frndz

Copper Contributor

Feb 17, 2020

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

SergeiBaklan

Diamond Contributor

Feb 17, 2020

c_frndz

Sorry, it shall be the opposite

=TODAY()>=$G$19

to check if the date in the cell is in the past

c_frndz
Copper Contributor
Feb 17, 2020
Thank you again. However, now the cell will remain remain even with no data.
- SergeiBaklan
  Diamond Contributor
  Feb 18, 2020
  c_frndz
  
  Forgot about blanks
  
  =(TODAY()>=$G$19)*($G$19>1)
  - c_frndz
    Copper Contributor
    Feb 18, 2020
    Sergei,
    
    Not sure what going on as I entered the formula as you have it. However, when I enter a date in the cell like 1/30/20 it highlights the cell yellow rather than red. And when I enter 3/30/20 it’s still yellow. Thanks again for your time.