Conditional Formatting

[Hc]

Hello,

Is it possible to make the colour of one cell conditional on the
contents of another cell?

For example, suppose I wanted cell A1 to turn red every time I typed "R"
into cell A2, would this be possible? I'm using Excel 2010.

Thanks.

 

[Claus Busch]

Hi,

Am Tue, 13 May 2014 19:28:56 +0100 schrieb Hc:

For example, suppose I wanted cell A1 to turn red every time I typed "R"
into cell A2, would this be possible? I'm using Excel 2010.

select A1 => CF => Use Formula to determine..... :
=A2="R"


Regards
Claus B.

 

[Hc]

Hi,

Am Tue, 13 May 2014 19:28:56 +0100 schrieb Hc:


select A1 => CF => Use Formula to determine..... :
=A2="R"


Regards
Claus B.

Thank you.