Conditional formatting dates

[FEVOOO]

Hey guy's,

I have sheet with some data for employe info. One column Is there ID's expire date
In this column I need to use the conditional formatting to make alert by green color before 2 month of the expire date and the yellow color before one month and from the expire date and up till today getting red.

Please help.

 

[Lisa Wilke-Thissen]

Hi,

I have sheet with some data for employe info.
One column Is there ID's expire date
In this column I need to use the conditional
formatting to make alert by green color
before 2 month of the expire date and the
yellow color before one month and from the
expire date and up till today getting red.

which version of Excel do you use?
Maybe, this article will help you:
http://www.techonthenet.com/excel/questions/cond_format4_2010.php

 

[FEVOOO]

Hi,












which version of Excel do you use?

Maybe, this article will help you:

http://www.techonthenet.com/excel/questions/cond_format4_2010.php



--

Cheers,

Lisa

Sorry but i need the expire dates which is written in the column it self, not today date

 

[Lisa Wilke-Thissen]

Hi,

[http://www.techonthenet.com/excel/questions/cond_format4_2010.php]

Sorry but i need the expire dates which
is written in the column it self, not today date

But the number of days between today's date and expire dates is important,
isn’t it?

1. Cell Value is less than or equal to =Today()
Format: Red

2. Cell Value is between =Today() and =Today()+30
Format: Yellow

3. Cell Value is greater than or equal to = Today()+60