background color

[Tommy]

I have a spreadsheet that I want everyother line to have a light blue
background for the color. But when I sort the sheet the background color
moves also. Can I do this without the color moving.

 

[Martin Fishlock]

Try conditional formating

Select the worksheet or the range

open up conditional formatting

select formula

and enter

=MOD(ROW(),2)

and ten select the pattern you want for it.

 

[Tommy]

Martin

Thank you but I want the letters to remain black and the background color to
be light blue, when I do what you told me to do it changed the letters.

 

[Gord Dibben]

Tommy

Sounds like you hit the Font tab instead of the Patterns Tab when you did the
Format step after entering Martin's formula.


Gord Dibben MS Excel MVP

 

[Tommy]

Gord Didden

You were right, I was just coming back to correct it. Thank You.