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.

Excel If statement for dates
Fenix internet on bank statement - Guide
Excel if statement - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Excel date format dd.mm.yyyy - Guide
Kernel for excel - Download - Backup and recovery

1 response

Answer 1 / 1

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.

Similar discussions

How to use conditional format based on text?

How to calculate positions (1st,2nd,3rd...) in Excel

Similar discussions

Subscribe To Our Newsletter!