Conditional Formatting

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.
 
C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top