You can do that with Conditional formatting:
Select the row or rows you want to change the font color of!
Format/Conditional formatting
1st condition Formula: =$A$1=2 choose blue font
2nd condition Formula: =$A$1=3 choose green font
3rd condition Formula: =$A$1=4 choose red font

If none ot the above conditions is met (that is $A$1=1), the font color
remains the default black.

Regards,
Stefi


€žMac€� ezt Ã*rta:

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