Change font/cell color by Formula

[exutable]

Hey how would I change the font/cell color with a formula, example
=IF(B6="green", fontcolor=green, fontcolor=red

 

[Otto Moehrbach]

You can't. Not with a formula. Look up Conditional Formatting in Help.
That will do what you want. HTH Otto

 

[Gord Dibben]

Formulas cannot format cells.

Have a look at your options under Format>Conditional Formatting

Condition 1>Cell Value is: "green" format green font

Note: you can have up to 3 conditions(4 if you count default)


Gord Dibben MS Excel MVP

 

[exutable]

How would I make it so that if cell B5 says green then C5 is green?

I had something like this =IF(C5="green",,)

 

[Otto Moehrbach]

Type "green" into B5 (without the quotes). Select C5. Click on Format -
Conditional Format. Select "Formula Is". In the formula block type
=B5="green" with the quotes. Select the Patterns tab and select the green
color you want. Click OK.
Done
HTH Otto