if function

[bholm]

How can I make the test of an If Function the color of the
font. i.e. if the font in Q10 is red test is true, if the
font is not red the test is false.

 

[Frank Kabel]

Hi
you'll need VBA for this. See:
http://www.cpearson.com/excel/colors.htm

 

[Bob Phillips]

There is also a usable function at

http://www.xldynamic.com/source/xld.ColourCounter.html

It focuses on counting the instances, but the function presented can do what
you want.