Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Background color in Excel 2007
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Background color in Excel 2007
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Background color in Excel 2007
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Background color in Excel 2007
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Background color in Excel 2007
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Background color in Excel 2007
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 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Background color in Excel 2007
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 |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Background color in Excel 2007
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find excel rows with a background color | Excel Discussion (Misc queries) | |||
Excel automatic background color | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
Excel 2003 Font Color and Background Color | Excel Discussion (Misc queries) | |||
Background color on Excel Spreadsheet | Excel Discussion (Misc queries) |