Thread: Excel 2003 bank ledger spreadsheet background fill shading
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Excel 2003 bank ledger spreadsheet background fill shading
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)


On Tue, 2 Dec 2008 09:59:01 -0800, Dan
wrote:

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.
Reply With QuoteReply With Quote