in excel, how do i get cell "A1" font to red when cell "A2" says h
 

in excel, how do i get cell "A1" font to red when cell "A2" says hot, and so
on down the list

also how do i get cell "A1" font to green when cell "A2" says cold??????

in excel, how do i get cell "A1" font to red when cell "A2" saysh
 

Hi,

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

=IF($A$2="Hot",TRUE,FALSE) and choose the format you need.

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

=IF($A$2="Cold",TRUE,FALSE) and choose the format you need.


Regards

Govind

Clownguy wrote:
in excel, how do i get cell "A1" font to red when cell "A2" says hot, and so
on down the list

also how do i get cell "A1" font to green when cell "A2" says cold??????

in excel, how do i get cell "A1" font to red when cell "A2" says h
 

Clownguy Wrote:
in excel, how do i get cell "A1" font to red when cell "A2" says hot,
and so
on down the list

also how do i get cell "A1" font to green when cell "A2" says
cold??????


Format Cell A1 as follows:

1. Go to "Format/Conditional Formatting"
2. For Condition 1, choose "Formula Is"
3. On the next box to the right, enter *=A2="hot"*
4. Click "Format"
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="cold"*
*** for step 5, choose color Green

9. Click OK
10. Click OK

Hope this is what you need.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=504266

in excel, how do i get cell "A1" font to red when cell "A2" says h
 

Select A1, then go to Format/Conditional Formatting, then select "formula is"
from the drop down menu and type:
=A2="hot"
click on format and format as you like, then click on add.....again select
"formula is" and type:
=A2="cold"
again click on format and format as you like and click OK OK.

HTH
JG


"Clownguy" wrote:

in excel, how do i get cell "A1" font to red when cell "A2" says hot, and so
on down the list

also how do i get cell "A1" font to green when cell "A2" says cold??????