Thanks for the quick answer...but..
I tried that and the message I got was "You cannot use relative reference in
conditional formatingcriteria for color scales,data bars or Icon sets"
Help
Ian M

"Ron de Bruin" wrote:

Check out CF

Hi pcor

Select the cells I37 to O41
On the Home tab choose Conditonal Formatting
Choose New rule
Choose "Use a formula to determine..........
Enter =I37=Today()
And pick a color



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"pcor" wrote in message ...
How do I write a formula to make the cells I37 to O41 blue background but
only when the current date is today's date
Thanks