LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mary Ann
 
Posts: n/a
Default Conditional Formatting and Subtotals

I have an invoice database and use subtotals from the Tools Menu to calculate
total, average and count, grouped by company. I want to use colour to make
the different types of calculation stand out. So, for example, colour the
totals one colour, the averages another colour and the counts yet another
colour. Ideally I would like to be able to colour both the text in the cells
which contain, for example €śCompany X Total€ť and the actual figure in the
corresponding cell.

Any ideas?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Subtotals slh Excel Discussion (Misc queries) 1 May 13th 05 01:26 PM
How do I use conditional formatting to change subtotals row format Ken Peterson Excel Worksheet Functions 3 March 24th 05 04:58 PM
formatting subtotals S. H. Drew Excel Discussion (Misc queries) 0 March 10th 05 04:05 PM


All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"