Change font color for row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Mac said:
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.
Click to expand...

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).
 
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:
 
Back
Top