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??????
|