E
exutable
Hey how would I change the font/cell color with a formula, example
=IF(B6="green", fontcolor=green, fontcolor=red
=IF(B6="green", fontcolor=green, fontcolor=red
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Otto Moehrbach
You can't. Not with a formula. Look up Conditional Formatting in Help.
That will do what you want. HTH Otto
That will do what you want. HTH Otto
G
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
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
E
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",,)
I had something like this =IF(C5="green",,)
O
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
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