Look to change font color within a cell formula

S

Steve Kaitz

Is there a way to change the font color within a cell forula. for example can I create a formula that starts with an If (A3> B3, C3/A3 and change color of font to red, C3/A3 and leave color black.)

Note, is is not a simple as the negative and positive change in color that is automatic with certain styles because the condition may be say Gross margin > 30%

I know I can probably write a macro that evaluates each cell and changes the font color but I dont know how to do that and figured I would check out this option first.

If you have any suggestions, please email me at [email protected]

Thanks

Steve
 
J

jeff

Hi,

Have you tried using Conditional formatting?

Menu>Format>Conditional formatting...

You can set your criterion and then click on "format"
to select either font or cell changes...

Only problem is you're limited to 3 (and a default)
conditions.

jeff
-----Original Message-----
Is there a way to change the font color within a cell
Click to expand...
forula. for example can I create a formula that starts
with an If (A3> B3, C3/A3 and change color of font to
red, C3/A3 and leave color black.)
Note, is is not a simple as the negative and positive
Click to expand...
change in color that is automatic with certain styles
because the condition may be say Gross margin > 30%
I know I can probably write a macro that evaluates each
Click to expand...
cell and changes the font color but I dont know how to do
that and figured I would check out this option first.
 
G

Gord Dibben

Steve

Have a look at Format>Conditional Formatting.

You can set up to 3 conditions, each with a different color.

Gord Dibben Excel MVP

On Tue, 22 Jun 2004 10:58:01 -0700, "Steve Kaitz" <Steve
 
Top