Conditional Formatting

  • Thread starter Thread starter Hc
  • Start date Start date
H

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.
 
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.
Click to expand...

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


Regards
Claus B.
 
Back
Top