Feb 17 2020 01:24 PM
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!
Feb 17 2020 02:03 PM
You may use with formulas
red
=A1>=TODAY()
yellow
=(TODAY()-A1)<30
the rest won't be formatted
Feb 17 2020 02:45 PM
@Sergei Baklan Thank you Sergei. Please see attached. It doesn't seem like the red formula worked unless i did it wrong. Please advise.
Feb 17 2020 02:53 PM
Sorry, it shall be the opposite
=TODAY()>=$G$19
to check if the date in the cell is in the past
Feb 17 2020 03:18 PM
Feb 18 2020 01:05 AM
Feb 18 2020 08:40 AM
Feb 18 2020 10:18 AM
Feb 19 2020 11:36 AM
@Sergei Baklan 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.