Change font/cell color by Formula
 

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


--
exutable
------------------------------------------------------------------------
exutable's Profile: http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=535363

Change font/cell color by Formula
 

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

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


--
exutable
------------------------------------------------------------------------
exutable's Profile:
http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=535363

Change font/cell color by Formula
 

Formulas cannot format cells.

Have a look at your options under FormatConditional Formatting

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

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


Gord Dibben MS Excel MVP

On Sun, 23 Apr 2006 17:11:26 -0500, exutable
wrote:


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

Change font/cell color by Formula
 

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

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


--
exutable
------------------------------------------------------------------------
exutable's Profile: http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=535363

Change font/cell color by Formula
 

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
"exutable" wrote in
message ...

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

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


--
exutable
------------------------------------------------------------------------
exutable's Profile:
http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=535363