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

FormatConditional Formatting will allow 3 conditions....4 if you count the
default.

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

Select A1 and FormatCFcondition1formula 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



On Thu, 16 Nov 2006 18:01:02 -0800, 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

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

Thank you - extremely helpful

Mac

"Gord Dibben" wrote:

FormatConditional Formatting will allow 3 conditions....4 if you count the
default.

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

Select A1 and FormatCFcondition1formula 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



On Thu, 16 Nov 2006 18:01:02 -0800, 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

Thanks for the feedback

Gord

On Thu, 16 Nov 2006 19:24:01 -0800, Mac wrote:

Thank you - extremely helpful

Mac

"Gord Dibben" wrote:

FormatConditional Formatting will allow 3 conditions....4 if you count the
default.

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

Select A1 and FormatCFcondition1formula 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



On Thu, 16 Nov 2006 18:01:02 -0800, 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




Gord Dibben MS Excel MVP