Excel 2003 bank ledger spreadsheet background fill shading

[Dan]

I created a very basic bank ledger spreadsheet with shading in alternate
cells. Whenever I make entries though the cell shading changes. How can I
save the ledger shading so that it doesn't change whenever I make entries?
Thanks in advance.

 

[David Biddulph]

How have you done the shading? Have you used Conditional formatting? If
so, what condition?

 

[Chip Pearson]

You can use Conditional Formatting to create bands of colored rows.
See http://www.cpearson.com/Excel/banding.htm for details.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Dan]

The way the shading was done was through the fill color option. Then I just
copied and pasted for the sheet.

 

[David Biddulph]

In which case the shading shouldn't change when you type anything in a cell.