Change font color across entire row

[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

 

[Gord Dibben]

Format>Conditional Formatting will allow 3 conditions....4 if you count the
default.

Maybe you you could have blue, green, red and default?

Select A1 and Format>CF>condition1>formula is: =$A$1=1

Format the Font to blue.

Add conditions 2 and 3 in similar fashion.

OR visit JE McGimpsey's site for a method of getting 6 font colors without
macros.

http://www.mcgimpsey.com/excel/conditional6.html


Gord Dibben MS Excel MVP

 

[Guest]

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

 

[Guest]

Thank you - extremely helpful

Mac

Format>Conditional Formatting will allow 3 conditions....4 if you count the
default.

Maybe you you could have blue, green, red and default?

Select A1 and Format>CF>condition1>formula is: =$A$1=1

Format the Font to blue.

Add conditions 2 and 3 in similar fashion.

OR visit JE McGimpsey's site for a method of getting 6 font colors without
macros.

http://www.mcgimpsey.com/excel/conditional6.html


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Thanks for the feedback

Gord

Thank you - extremely helpful

Mac

Gord Dibben MS Excel MVP