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