Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet with customer's account numbers in column A and other
data associated with the account number through column Z. I'm looking for a way to use the fill color (gray) for the entire row if the account numbers match, then for the next match use fill color (white) and so on. A 1 12345 gray 2 12345 gray 3 12345 gray 4 67891 white 5 67891 white 6 57842 gray 7 54123 white 8 54123 white Thanks in advance for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I automatically color a cell based upon a condition being | Excel Worksheet Functions | |||
Fill a cell based on a condition being met | Excel Worksheet Functions | |||
Change row color based on condition of celss | Excel Worksheet Functions | |||
I want to fill the cell color based upon the other cell condition | Excel Discussion (Misc queries) | |||
Color Change in chart based of condition | Charts and Charting in Excel |