Forum Discussion

c_frndz's avatar
c_frndz
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
SergeiBaklan's avatar
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's avatar
c_frndz
Copper Contributor
Feb 17, 2020
Thank you again. However, now the cell will remain remain even with no data.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Feb 18, 2020

    c_frndz 

    Forgot about blanks

    =(TODAY()>=$G$19)*($G$19>1)
    • c_frndz's avatar
      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.

Resources