Sorting without moving background color

[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

 

[Don Guillett]

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!

 

[Gord Dibben]

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

 

[JD]

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)



.

 

[JD]

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

 

[Don Guillett]

glad to help