Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |