Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I sort row data without row fill color moving as well?
|
#2
|
|||
|
|||
In format|Conditional formating|Formula is: you can place a formula like =MOD(ROW(),6)<3 and select a background pattern This will produce as an example 3 lines of background color alternating with 3 lines of white. Since it is based on the row() number it will not shift when you sort Lance "Scouter" wrote: I am trying to sort the data in a spreadsheet without my row fill color(shading) also sorting with the row contents. reply to : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Keeping Row 1 at the top during a Data Sort... | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Data Sort | Excel Worksheet Functions |