Change font color for row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mac - 17 Nov 2006 01:45 GMT

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

Reply to this Message

Andy Brown - 17 Nov 2006 09:27 GMT

> 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).

Reply to this Message

Stefi - 17 Nov 2006 09:38 GMT

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
[quoted text clipped - 4 lines]
>
> Mac

Reply to this Message

Rate this thread: