software

Hey how would I change the font/cell color with a formula, example:
=IF(B6=quot;greenquot;, fontcolor=green, fontcolor=red)--
exutable
------------------------------------------------------------------------
exutable's Profile: www.excelforum.com/member.php...oamp;userid=28665
View this thread: www.excelforum.com/showthread...hreadid=535363You can't. Not with a formula. Look up Conditional Formatting in Help.
That will do what you want. HTH Otto
quot;exutablequot; gt; wrote in
message ...
gt;
gt; Hey how would I change the font/cell color with a formula, example:
gt; =IF(B6=quot;greenquot;, fontcolor=green, fontcolor=red)
gt;
gt;
gt; --
gt; exutable
gt; ------------------------------------------------------------------------
gt; exutable's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28665
gt; View this thread: www.excelforum.com/showthread...hreadid=535363
gt;
Formulas cannot format cells.

Have a look at your options under Formatgt;Conditional Formatting

Condition 1gt;Cell Value is: quot;greenquot; 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
gt; wrote:

gt;
gt;Hey how would I change the font/cell color with a formula, example:
gt;=IF(B6=quot;greenquot;, fontcolor=green, fontcolor=red)
How would I make it so that if cell B5 says green then C5 is green?

I had something like this =IF(C5=quot;greenquot;,,)--
exutable
------------------------------------------------------------------------
exutable's Profile: www.excelforum.com/member.php...oamp;userid=28665
View this thread: www.excelforum.com/showthread...hreadid=535363Type quot;greenquot; into B5 (without the quotes). Select C5. Click on Format -
Conditional Format. Select quot;Formula Isquot;. In the formula block type
=B5=quot;greenquot; with the quotes. Select the Patterns tab and select the green
color you want. Click OK.
Done
HTH Otto
quot;exutablequot; gt; wrote in
message ...
gt;
gt; How would I make it so that if cell B5 says green then C5 is green?
gt;
gt; I had something like this =IF(C5=quot;greenquot;,,)
gt;
gt;
gt; --
gt; exutable
gt; ------------------------------------------------------------------------
gt; exutable's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28665
gt; View this thread: www.excelforum.com/showthread...hreadid=535363
gt;