CONDITIONAL FORMATTING IN EXCEL 2010

M

Malcolm Austin

Sorry, this is obviously a really simply one, but the help comments are not
making sense to me!

I wish to format A1 (background colour) when its value is higher than B1.

As in:-

A1 = 3.3% B1 = 2.8% so cell A1 background colour will change.

Thanks for the help!

Malcolm..
 
C

Claus Busch

Hi Malcom,

Am Thu, 16 May 2013 12:08:23 +0100 schrieb Malcolm Austin:
I wish to format A1 (background colour) when its value is higher than B1.

As in:-

A1 = 3.3% B1 = 2.8% so cell A1 background colour will change.

select A1 => Conditional Formating => New Rule => Use formula to
determine which cells to format and enter the formula:
=A1>B1 and choose your expected format


Regards
Claus Busch
 

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