Background color in Excel 2007

[Guest]

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

 

[Ron de Bruin]

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

 

[Guest]

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]

Hi pcor

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

=I37=Today()

 

[Guest]

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]

Send me your test workbook private and I look at it

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

 

[Guest]

I just sent it to you and many thanks

Send me your test workbook private and I look at it

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

 

[Ron de Bruin]

Got it, I look at it this evening