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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I sort row data without row fill color moving as well? (https://www.excelbanter.com/excel-worksheet-functions/16491-how-do-i-sort-row-data-without-row-fill-color-moving-well.html)

Scouter

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

I am trying to sort the data in a spreadsheet without my row fill
color(shading) also sorting with the row contents. reply to :

LanceB

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 :

All times are GMT +1. The time now is 09:48 PM.