Background color in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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
 
Back
Top