LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Laura
 
Posts: n/a
Default I can't figure out how to add values based on font color.

I'm trying to add values in a chart based on color only - for example, I've
put charge card purchases in blue and debit card purchases in green, and
would like my totals at the bottome of the spreadsheet to add all of the
credit card purchases, and then all of the debit card purchases. This is
hard to explain in words, I hope someone can help.
 
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
list two columnar values based on conditional formating (text color) beechum1 Excel Worksheet Functions 2 February 12th 06 09:53 AM
Return Range of Numerical Values in Single Column based on Frequency Percentage Sam via OfficeKB.com Excel Worksheet Functions 9 October 28th 05 11:01 PM
FONT COLOR FORMAT JMCA2000 Excel Discussion (Misc queries) 6 August 23rd 05 07:48 AM
Excel 2003 Font Color and Background Color DrankPA6 Excel Discussion (Misc queries) 1 August 12th 05 11:43 PM
I have cells with diffent color fonts and need to total based on . KyaraB Excel Discussion (Misc queries) 1 April 20th 05 05:28 PM


All times are GMT +1. The time now is 04:22 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"