Conditional Format - 3 conditions


G

Guest

Greetings,

I checked previous posts and found, what I thought was, an answer to my
problem with conditional formatting based on nested IF's. No Joy, I'm still
doing something wrong. Help?

In cell I69 is a percentage of achieved sales.
I want to color the cell I71 either red, yellow or green, based on the % in
I69.

Cell I71 contains no data. It's just a visual aid to draw attention to the
performance of the salesperson in Column I.

My scale is this:
If I69 is 0 to 92% Format I71 background Red
If I69 is 93 to 97% Format I71 background Yellow
If I69 is 98 to 100% Format I71 background Green

This is what I have done so far:

Selected cell I69
Selected Format > Conditional Formatting

Condition 1 - Formula is =I69<=92 Format... Red
Condition 2 - Formula is =AND(I69>92,I69<98) Format... Yellow
Condition 3 - Formula is =I69>=98 Format...Green

Well, it's not working. No matter what the percentage is in cell I69,
cell I71 is stuck on Red. Like a bad stoplight.

Where am I wrong in my formatting?
Thanks a lot.
 
Ad

Advertisements

G

Guest

Ooops, correction.

I wrote this:
"> This is what I have done so far:
Selected cell I69
Selected Format > Conditional Formatting"

I meant "Selected cell I71"

Sorry,
Mike
 
B

Bob Phillips

Use

Condition 1 - Formula is =I69<=92%
Condition 2 - Formula is =I69<98%
Condition 3 - Formula is =I69>=98%

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Ad

Advertisements

G

Guest

Hello Bob,
Thank you. Works perfectly now.
Best,

--
Mike
Jacksonville, Florida


Bob Phillips said:
Use

Condition 1 - Formula is =I69<=92%
Condition 2 - Formula is =I69<98%
Condition 3 - Formula is =I69>=98%

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

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