Is there any way to tell excel to put a color pattern on a group of
cells based on date.
In other words can I have it automatically place a light blue background
on a range of cells covering the 1st week of the month, light yellow for
2nd week and so on?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Dale,

Conditional formatting with a formula could work. The trick is to have a
clear formula to identify the first week. If it's always the first 7 days,
then a formula such as
=DAY(A1)<8

and set the format accordingly.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dale Herring" wrote in message
...


Is there any way to tell excel to put a color pattern on a group of
cells based on date.
In other words can I have it automatically place a light blue background
on a range of cells covering the 1st week of the month, light yellow for
2nd week and so on?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!