software

in excel, how do i get cell quot;A1quot; font to red when cell quot;A2quot; says hot, and so
on down the list

also how do i get cell quot;A1quot; font to green when cell quot;A2quot; says cold??????

Hi,

Select cell A1, go to Format-gt;conditional formatting and choose 'Formula
is' and type

=IF($A$2=quot;Hotquot;,TRUE,FALSE) and choose the format you need.

and then add a condition, choose 'Formula is' and type

=IF($A$2=quot;Coldquot;,TRUE,FALSE) and choose the format you need.Regards

Govind

Clownguy wrote:
gt; in excel, how do i get cell quot;A1quot; font to red when cell quot;A2quot; says hot, and so
gt; on down the list
gt;
gt; also how do i get cell quot;A1quot; font to green when cell quot;A2quot; says cold??????


Clownguy Wrote:
gt; in excel, how do i get cell quot;A1quot; font to red when cell quot;A2quot; says hot,
gt; and so
gt; on down the list
gt;
gt; also how do i get cell quot;A1quot; font to green when cell quot;A2quot; says
gt; cold??????Format Cell A1 as follows:

1. Go to quot;Format/Conditional Formattingquot;
2. For Condition 1, choose quot;Formula Isquot;
3. On the next box to the right, enter *=A2=quot;hotquot;*
4. Click quot;Formatquot;
5. Choose color Red (Color box is located somewhere in the middle)
6. Click OK
7. Click ADD
8. For condition 2, do steps 1 through 5 with the following
differences:

*** for step 3, enter *=A2=quot;coldquot;*
*** for step 5, choose color Green

9. Click OK
10. Click OK

Hope this is what you need.

Regards.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=504266Select A1, then go to Format/Conditional Formatting, then select quot;formula isquot;
from the drop down menu and type:
=A2=quot;hotquot;
click on format and format as you like, then click on add.....again select
quot;formula isquot; and type:
=A2=quot;coldquot;
again click on format and format as you like and click OK OK.

HTH
JGquot;Clownguyquot; wrote:

gt; in excel, how do i get cell quot;A1quot; font to red when cell quot;A2quot; says hot, and so
gt; on down the list
gt;
gt; also how do i get cell quot;A1quot; font to green when cell quot;A2quot; says cold??????