FormatConditional Formatting will allow 3 conditions....4 if you count the
default.

Maybe you you could have blue, green, red and default?

Select A1 and FormatCFcondition1formula is: =$A$1=1

Format the Font to blue.

Add conditions 2 and 3 in similar fashion.

OR visit JE McGimpsey's site for a method of getting 6 font colors without
macros.

http://www.mcgimpsey.com/excel/conditional6.html


Gord Dibben MS Excel MVP



On Thu, 16 Nov 2006 18:01:02 -0800, Mac wrote:

If A1 is numbered 1 thru 4, representing Black, blue, green and red, is there
a way to change the font color for an entire row based on this? i.e. if I
place a 2 in cell A1, I would like the entire row of numbers and statements
to change to a blue font.

Thanks in Advance

Mac