Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - 3 conditions
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(I6992,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. -- Mike Jacksonville, Florida |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - 3 conditions
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 -- Mike Jacksonville, Florida "Mike Saffer" wrote: 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(I6992,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. -- Mike Jacksonville, Florida |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - 3 conditions
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) "Mike Saffer" wrote in message ... 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(I6992,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. -- Mike Jacksonville, Florida |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - 3 conditions
Hello Bob,
Thank you. Works perfectly now. Best, -- Mike Jacksonville, Florida "Bob Phillips" wrote: 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) "Mike Saffer" wrote in message ... 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(I6992,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. -- Mike Jacksonville, Florida |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format in merged cells. | Excel Discussion (Misc queries) | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Conditional format question | Excel Discussion (Misc queries) | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |