Previous Topic Next Topic

Excel If statement for dates

Closed
dhamilton Posts 1 Registration date Tuesday 3 December 2013 Status Member Last seen 3 December 2013 - 3 Dec 2013 à 22:02
 Blocked Profile - 5 Dec 2013 à 11:58
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

Réponse 1 / 1
Blocked Profile
5 Dec 2013 à 11:58
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.

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses
Using IF function with dates
dkayeh1 -
RayH -

18 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses