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