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