Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
have a list of 200 accounts indentified with unique account numbers. each of
these accounts may have from one to x entries that would begin with account number in column 2. these rows are sorted in ascending order i'd like to use one green row and a default white row such that all of the same account number entries would bee the same color and the next set of account number would be the alternate color. eg: Line # Acct# Date Result 1 1 .... .... 2 1 3 2 4 3 Lines 1,2 and 4 would be green and line 3 would be white and so forth. any suggestions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |