How do I fix the background shading by position?

G

Guest

I wish to shade the background with alternating stripes of light-blue and
white for legibility of the data output (similar to the old computer
print-out paper).

I can cut and paste the format, but when I do a data sort, it takes to cell
shading along with it. Is there a way to create a fixed background that does
not move if I sort, insert, or delete cells?
 
G

Guest

Use conditional formatting (Format->Conditional Formatting)

Select the range you want formatted this way, THEN use the menu to open the
dialog box. Use Formula Is and the formula would be

=Mod(row(),2)=0

Click on the format button and go to the Pattern tab and choose the color
you want
Click on OK, then click on the Add button (I think it's Add, or new
condition, or such). Again use Formula Is and use

=Mod(row(),2)=1

Repeat the earlier steps but choose the alternating color
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row Shading 1
How do I alternate shading of rows, Excel 2007, no new tabs. 1
Cell shading with conditional formatting 5
How do I use different colours in drop down menus in Excel 2003? 4
How do I change the background color of margins or headers? 1
How do I remove background shading 2
How do I filter or sort by cell shading? 2
How do I remove a light blue background on a word document? 5

Top