Posted to microsoft.public.excel.programming

RockNRoll[_2_] RockNRoll[_2_] is offline

external usenet poster

Posts: 3

Sum a row of data based on FONT COLOR (

Alright, here's one for you. Sort of a wacky "SUMIF" function needed. Can
I conditionally sum a row of data in a worksheet if the font color is black?
Sample data

Column A Column B Column C Column D Column E Column F
(Normal Sum) Column G (Conditional color Sum)
1000(Black) 2000 (Red) 2000 (Black) 4000(Black) 1000(Green) 10,000
(1000+2000+4000)=7,000

Thanks for your help,
-Dave

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
More Functions based on Font Color	michelle	New Users to Excel	2	September 3rd 08 08:56 PM
Condition font color in a single cell based on its formula data.	Bee	Excel Worksheet Functions	3	February 19th 08 12:09 AM
Changing Font color based on font type or size	John	Excel Discussion (Misc queries)	2	February 7th 08 12:50 AM
change font color based on a value	Golf Nut[_2_]	Excel Worksheet Functions	1	April 26th 07 03:30 PM
How to sum data based on font or cell color?	techiesol	Excel Worksheet Functions	6	May 24th 06 04:11 PM

All times are GMT +1. The time now is 08:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us