Conditional Formatting
condition1: =A1=2 (format as blue)
condition2: =A2=3 (format as green)
condition3: =A3=4 (format as red)


"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