Forum Discussion
Excel Formula - formula based on either today's date OR entered date to turn cell color
I have Excel 2010 The column AA will be based on two things…the date in AB and/or the current date. The objective is to turn the cell in AA yellow, orange or red based on the proximity of the...
Hi Betty,
You may use conditional formatting https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f applying 3 rules,
for red like
=IF(ISBLANK($AB1),TODAY(),$AB1)-$AA1<0
and <=2 for orange; <=5 for yellow. Put red rule on the top, next orange, next yellow.