Sorting without moving background color

  • Thread starter Thread starter JD
  • Start date Start date
J

JD

Is there a way to sort the data without moving the
background along with it?

I have my sheet set up for every other row to be light
green (like the old computer paper). When I sort, the
background color goes along with it and I end up getting
greens and whites next together.

Thanks,

JD
 
Change all of your formatting back to normal. Select the area to format. Use
format>conditional formating>formula is>=mod(row(),2)=0 and format patterns
to light green
Voila!
 
JD

Format the rows using Conditional Formatting.

Select 100 rows(or whatever) then Format>Conditional
Formatting>Condition1>Formula is.....

Enter =MOD(ROW(),2)=1

Pick a color from the Format>Patterns dialog then OK your way out.

The rows will remain alternately colored throughout sorts and deletions or
insertions.

Gord Dibben XL2002
 
Thanks for the info!
-----Original Message-----
Change all of your formatting back to normal. Select the area to format. Use
format>conditional formating>formula is>=mod(row(),2)=0 and format patterns
to light green
Voila!
--
Don Guillett
SalesAid Software
(e-mail address removed)



.
Click to expand...
 
Thanks for the info!
-----Original Message-----
JD

Format the rows using Conditional Formatting.

Select 100 rows(or whatever) then Format>Conditional
Formatting>Condition1>Formula is.....

Enter =MOD(ROW(),2)=1

Pick a color from the Format>Patterns dialog then OK your way out.

The rows will remain alternately colored throughout sorts and deletions or
insertions.

Gord Dibben XL2002
Click to expand...
 
Back
Top