Take a look at Chip Pearson's site:
http://cpearson.com/excel/banding.htm
He uses format|conditional formatting to accomplish this.
Another way (more manual, though) is to
select your range
then apply Format|Autoformat.
You may have to reapply depending on what you change--but they have some pretty
choices there.
tjsmags wrote:
I would like to alternate colors (white, yellow) for each row in my
spreadsheet. Do I have to create a table to do this? I want it to
automatically know which color to add if I insert a row anywhere in the
spreadsheet, and then adjust the rest of the rows automatically. Is this
possible?
--
Dave Peterson