How do I choose a cell colour, without it being tied to the data?

[Guest]

I would like to set up an alternating cell colour scheme to distinguish
between each line of data in my table. However, when I do this, and then
sort the data after it is updated, the cell colour moves with the data. Is
there any way to select the cell background colour permanantly so that it is
not tied to the data for when I sort it?

 

[Anne Troy]

Try this: http://www.cpearson.com/excel/banding.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.CF.html#rows

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

I haven't read the links the other guys supplied, but here is how I
accomplish your problem.

1. Highlight entire document.
2. Select the formatting you want for all odd numbered rows. (at this
point all cells will be formatted the same).
3. With everything still highlighted Goto Format->Conditional Formattting
4. Select "Formula Is"
5. =MOD(ROW(A1),2)=0
6. Select the formatting you want for all even numbered rows by clicking on
the "Format" button.
7. Select "Okay"