Conditional formatting

[Ed]

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

 

[JLGWhiz]

maybe this will work for you:

http://office.microsoft.com/en-us/excel/HA011373371033.aspx?pid=CL100570551033

 

[Ed]

maybe this will work for you:

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

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