You conditional formatting formula for cell C2 is:

=DATE(YEAR(TODAY()),TEXT(1&" "&C$1&" "&2000,"mm"),DAY($B2)) = TODAY()

NOTE: TEXT(1&" "&C$1&" "&2000,"mm") converts JAN, FEB, MAR to 01. 02, 03 for
the Date() function. It will also convert January, February, March.
--
Steve

"MAX" wrote in message
...
Here I have a calendar where every day has 2 rows. In this example let say
that today's date is 1st January. I need that cell B2 (Highlight) will be
highlighted with any colour as I open the file and cell B3 (Details)
remains
empty where I can put my details. Any help please?

Thanks in adnance.

A B C D E F
__________________________________________________ __
1 JAN FEB MAR APR MAY
__________________________________________________ __
2 1 Highlight
3 Details
__________________________________________________ ___
4 2
5
__________________________________________________ ____
6 3
7
__________________________________________________ ____
8 4
9
__________________________________________________ ______