| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Alternating colors for rows
I'd like to be able to have alternating colors for each of my rows. Example
(gray-blue-gray-blue etc.). If I just change the color of the row then the change around when I do a sort. Is there a way to lock these colors in place? Thanks |
|
#2
|
|||
|
|||
|
See www.cpearson.com/excel/banding.htm for a way to do this with
Conditional Formatting. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jp" wrote in message ... I'd like to be able to have alternating colors for each of my rows. Example (gray-blue-gray-blue etc.). If I just change the color of the row then the change around when I do a sort. Is there a way to lock these colors in place? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colors of columns after sorting data in the supporting table | Charts and Charting in Excel | |||
| Custome Colors? | Charts and Charting in Excel | |||
| EXCEL cells colors | Excel Discussion (Misc queries) | |||
| how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
| One bar, Two colors? | Charts and Charting in Excel | |||
Hybrid Mode
