Sorry try this formula for your Conditional Format
=COUNTIF($A$1:$C$30, "" & VALUE(DATE(2005,3,31))) red
=COUNTIF($A$1:$C$30, "" & VALUE(DATE(2005,3,0))) yellow
don't know what I was thinking of when I thought your previous
formula had anything to do with VLOOKUP.
Preselect the cells that you want to receive the color, which
I think they are A1:C30, since address is an absolute address
it really won't make any difference which cell is active because
the formula is not going to be changed when applied to different
cells.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Kevin" wrote in message ...
Hi David,
Thanks that did work but what if I have a few different cells with different
dates in them for different trianing?
eg: c46 march 1 d46 june 1 e46 april 1
So I would like A1:C30 to turn red when any of the cells gets to the date
and yellow 1 month previous.