How do I sort row data without row fill color moving as well?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sort the data in a spreadsheet without my row fill
color(shading) also sorting with the row contents. reply to :
(e-mail address removed)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting rows 3
How can you sort an Excel table by the color a row is shaded? 1
Row Colors 2
Hpw do I delete multiple empty rows found between filled rows? 1
Excel VBA 1
Series fill only copying and fill series greyed out 1
Sorting by colors 1
highlight subtotal rows with a fill color 1

Back
Top