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

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.
- SergeiBaklan
  Diamond Contributor
  Feb 18, 2020
  c_frndz
  
  Is it shall be as here?
  
  Please check CF rules in attached file
  CF 30 days.xlsx17 KB
  - c_frndz
    Copper Contributor
    Feb 19, 2020
    SergeiBaklan I thank you for all your help and apologize as I'm a little confused. So basically i want a cell to turn yellow when it is 30 days or less from the expiration date. Turn red once it reaches or surpassses the the expiration date. Have no color when there is no data in the cell.