Got it, I look at it this evening

--

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


"pcor" wrote in message ...
I just sent it to you and many thanks

"Ron de Bruin" wrote:

Send me your test workbook private and I look at it

Adress is on this page
http://www.rondebruin.nl/


--

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


"pcor" wrote in message ...
I have done as you said: selected I37 to O41
then New rule but I keep on getting the same error message
I appreciate all the hlp you can give me
Thanks



"Ron de Bruin" wrote:

Hi pcor

Note: that I37 is also the first cell in your selection

=I37=Today()


--

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


"pcor" wrote in message ...
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