"Mac" wrote in message
...
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.

Conditional formatting can do this.

Selecting all of row 1 (click the row number 1, left of A1), then
Conditional Formatting from the Format menu.

For Condition 1, select Formula Is and enter =$A1=2 ; then click Format. On
the Font tab, set Color to blue -- click OK, and OK again.

Repeat the process to add 2 further conditions: =$A1=3 (green font) and
=$A1=4 (red font).