software

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 gt; Conditional Formatting

Condition 1 - Formula is =I69lt;=92 Format... Red
Condition 2 - Formula is =AND(I69gt;92,I69lt;98) Format... Yellow
Condition 3 - Formula is =I69gt;=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.

--
Mike
Jacksonville, Florida

Ooops, correction.

I wrote this:
quot;gt; This is what I have done so far:
gt;
gt; Selected cell I69
gt; Selected Format gt; Conditional Formattingquot;

I meant quot;Selected cell I71quot;

Sorry,
Mike--
Mike
Jacksonville, Floridaquot;Mike Safferquot; wrote:

gt; Greetings,
gt;
gt; I checked previous posts and found, what I thought was, an answer to my
gt; problem with conditional formatting based on nested IF's. No Joy, I'm still
gt; doing something wrong. Help?
gt;
gt; In cell I69 is a percentage of achieved sales.
gt; I want to color the cell I71 either red, yellow or green, based on the % in
gt; I69.
gt;
gt; Cell I71 contains no data. It's just a visual aid to draw attention to the
gt; performance of the salesperson in Column I.
gt;
gt; My scale is this:
gt; If I69 is 0 to 92% Format I71 background Red
gt; If I69 is 93 to 97% Format I71 background Yellow
gt; If I69 is 98 to 100% Format I71 background Green
gt;
gt; This is what I have done so far:
gt;
gt; Selected cell I69
gt; Selected Format gt; Conditional Formatting
gt;
gt; Condition 1 - Formula is =I69lt;=92 Format... Red
gt; Condition 2 - Formula is =AND(I69gt;92,I69lt;98) Format... Yellow
gt; Condition 3 - Formula is =I69gt;=98 Format...Green
gt;
gt; Well, it's not working. No matter what the percentage is in cell I69,
gt; cell I71 is stuck on Red. Like a bad stoplight.
gt;
gt; Where am I wrong in my formatting?
gt; Thanks a lot.
gt;
gt; --
gt; Mike
gt; Jacksonville, Florida

Use

Condition 1 - Formula is =I69lt;=92%
Condition 2 - Formula is =I69lt;98%
Condition 3 - Formula is =I69gt;=98%

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Mike Safferquot; gt; wrote in message
...
gt; Greetings,
gt;
gt; I checked previous posts and found, what I thought was, an answer to my
gt; problem with conditional formatting based on nested IF's. No Joy, I'm
still
gt; doing something wrong. Help?
gt;
gt; In cell I69 is a percentage of achieved sales.
gt; I want to color the cell I71 either red, yellow or green, based on the %
in
gt; I69.
gt;
gt; Cell I71 contains no data. It's just a visual aid to draw attention to
the
gt; performance of the salesperson in Column I.
gt;
gt; My scale is this:
gt; If I69 is 0 to 92% Format I71 background Red
gt; If I69 is 93 to 97% Format I71 background Yellow
gt; If I69 is 98 to 100% Format I71 background Green
gt;
gt; This is what I have done so far:
gt;
gt; Selected cell I69
gt; Selected Format gt; Conditional Formatting
gt;
gt; Condition 1 - Formula is =I69lt;=92 Format... Red
gt; Condition 2 - Formula is =AND(I69gt;92,I69lt;98) Format... Yellow
gt; Condition 3 - Formula is =I69gt;=98 Format...Green
gt;
gt; Well, it's not working. No matter what the percentage is in cell I69,
gt; cell I71 is stuck on Red. Like a bad stoplight.
gt;
gt; Where am I wrong in my formatting?
gt; Thanks a lot.
gt;
gt; --
gt; Mike
gt; Jacksonville, Florida
Hello Bob,
Thank you. Works perfectly now.
Best,

--
Mike
Jacksonville, Floridaquot;Bob Phillipsquot; wrote:

gt; Use
gt;
gt; Condition 1 - Formula is =I69lt;=92%
gt; Condition 2 - Formula is =I69lt;98%
gt; Condition 3 - Formula is =I69gt;=98%
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Mike Safferquot; gt; wrote in message
gt; ...
gt; gt; Greetings,
gt; gt;
gt; gt; I checked previous posts and found, what I thought was, an answer to my
gt; gt; problem with conditional formatting based on nested IF's. No Joy, I'm
gt; still
gt; gt; doing something wrong. Help?
gt; gt;
gt; gt; In cell I69 is a percentage of achieved sales.
gt; gt; I want to color the cell I71 either red, yellow or green, based on the %
gt; in
gt; gt; I69.
gt; gt;
gt; gt; Cell I71 contains no data. It's just a visual aid to draw attention to
gt; the
gt; gt; performance of the salesperson in Column I.
gt; gt;
gt; gt; My scale is this:
gt; gt; If I69 is 0 to 92% Format I71 background Red
gt; gt; If I69 is 93 to 97% Format I71 background Yellow
gt; gt; If I69 is 98 to 100% Format I71 background Green
gt; gt;
gt; gt; This is what I have done so far:
gt; gt;
gt; gt; Selected cell I69
gt; gt; Selected Format gt; Conditional Formatting
gt; gt;
gt; gt; Condition 1 - Formula is =I69lt;=92 Format... Red
gt; gt; Condition 2 - Formula is =AND(I69gt;92,I69lt;98) Format... Yellow
gt; gt; Condition 3 - Formula is =I69gt;=98 Format...Green
gt; gt;
gt; gt; Well, it's not working. No matter what the percentage is in cell I69,
gt; gt; cell I71 is stuck on Red. Like a bad stoplight.
gt; gt;
gt; gt; Where am I wrong in my formatting?
gt; gt; Thanks a lot.
gt; gt;
gt; gt; --
gt; gt; Mike
gt; gt; Jacksonville, Florida
gt;
gt;
gt;