Excel If statement for dates

[Closed]
Report
Posts
1
Registration date
Tuesday December 3, 2013
Status
Member
Last seen
December 3, 2013
-
 Blocked Profile -
Hello,

I was wondering if there was a way that I could set an if statement that would change the color of box to red if it's 2 months ahead of today, yellow if it's 3 months ahead of today, and green for 4+ months ahead.

1 reply


Good Morning.

What you are trying to accomplish is called, Conditional Formatting. It is a built in funciton with Excel. There are plenty of resources if you cannot figure out by the Inline Help.