Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting data while the shading stays the same
I downloaded the Job Search template from the Office Website. I have 50
entries. the first line is white anda the 2nd is gray and the third is white.......I am trying to sort it and check for duplicate entries, When I sort it the row shading gets moved to. How do i keep the shading in the same row and just sort the text. |
#2
|
|||
|
|||
Hi
use conditional formatting. See: http://www.cpearson.com/excel/banding.htm -- Regards Frank Kabel Frankfurt, Germany Kyle wrote: I downloaded the Job Search template from the Office Website. I have 50 entries. the first line is white anda the 2nd is gray and the third is white.......I am trying to sort it and check for duplicate entries, When I sort it the row shading gets moved to. How do i keep the shading in the same row and just sort the text. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Colors of columns after sorting data in the supporting table | Charts and Charting in Excel | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Sorting data in Pivot Tables | Excel Discussion (Misc queries) | |||
use data on master worksheet for sorting | New Users to Excel |