On Tuesday, December 10, 2013 7:17:49 PM UTC+3, Lisa Wilke-Thissen wrote:
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/qu...rmat4_2010.php



--

Cheers,

Lisa

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