| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i keep the colors applied to the specific rows when sor
Ok, I tried using cpearson's website and it was just way to complicated for
me to understand. I need every other row coloured tan and all the others white. I also need them to stay that way when I sort. I need this to start in row 3. What would be the formula or what else would I do? God Bless, Harley "Debra Dalgleish" wrote: You could use conditional formatting to colour the rows. Chip Pearson has instructions on his web site: http://www.cpearson.com/excel/banding.htm evas1ve wrote: I have applied specific colors to specifc rows, but when i sort the colored rows follow the sorting format. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Display specific rows from table on other worksheet | Excel Discussion (Misc queries) | |||
| Alternating colors for rows | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| How do I get a specific list of rows out of a much larger excel s. | Excel Worksheet Functions | |||
Threaded Mode
