Excel If statement for dates

Closed
dhamilton Posts 1 Registration date Tuesday December 3, 2013 Status Member Last seen December 3, 2013 - Dec 3, 2013 at 10:02 PM
 Blocked Profile - Dec 5, 2013 at 11:58 AM
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.

Related:

1 response

Blocked Profile
Dec 5, 2013 at 11:58 AM
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.