Hi, I am hoping someone can give me some assistance on this.

I have a spreadsheet with multiple columns and rows, the data is
sorted by employee then on date. I want to conditionally format the
rows based on the dates in the date column.Alternating background
colors from one date to the next.

Example:

all rows for May 1 would have a gray background and all rows for May
2 would have no back ground color.

Any help you can provide will be greatly appreciated.


Thanks

Ed

maybe this will work for you:

http://office.microsoft.com/en-us/ex...CL100570551033

"Ed" wrote:

Hi, I am hoping someone can give me some assistance on this.

I have a spreadsheet with multiple columns and rows, the data is
sorted by employee then on date. I want to conditionally format the
rows based on the dates in the date column.Alternating background
colors from one date to the next.

Example:

all rows for May 1 would have a gray background and all rows for May
2 would have no back ground color.

Any help you can provide will be greatly appreciated.


Thanks

Ed

On Jul 2, 5:42*pm, JLGWhiz wrote:
maybe this will work for you:

http://office.microsoft.com/en-us/ex...aspx?pid=CL100...

"Ed" wrote:
Hi, I am hoping someone can give me some assistance on this.

I have a spreadsheet with multiple columns and rows, the data is
sorted by employee then on date. I want to conditionally format the
rows based on the dates in the date column.Alternating background
colors from one date to the next.

Example:

*all rows for May 1 would have a gray background and all rows for May
2 would have no back ground color.

Any help you can provide will be greatly appreciated.

Thanks

Ed
Thanks for the response, but my problem is that the rows with dates
vary. so there may be 5 rows with May the 1st and 10 rows with May the
2nd. The May the 3 may have one row. My clients requirement is that
each there be the alternate shading as in your example only instead of
every other row, it is every other date.. I know my explanation is
probably unclear. sorry.


Ed