protect row color

  • Thread starter Thread starter KIRK
  • Start date Start date
K

KIRK

I have a spread shhet that I have alternating row colors.
If I do a data sort it moves the color along with the
data.
How do I protect the rows format so this does not happen
 
Sounds as if the rows were coloured manually.
Remove the colours, select the rows to shade using Format|Conditional
Formatting.
One way to specify every second row is MOD(ROW(),2)=0

Bernard
 
Back
Top