Hi
see: http://www.cpearson.com/excel/colors.htm

--
Regards
Frank Kabel
Frankfurt, Germany


RockNRoll wrote:
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