Hi,

[http://www.techonthenet.com/excel/qu...mat4_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,
isnt 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

--
Cheers,
Lisa