Selecting text and having different color backgrounds appear

steelers777

New Member
Joined
Sep 23, 2006
Messages
16
I have an excel document and I created a data distribution list where in one cell I can select among 24 different employees. I have the employees broken down into the top 20% (Green), middle 60% (Yellow), and bottom 20% (Red). When the employees name is selected in the cell I want the background color to change to the appropriate color. I have went into conditional formatting and thought I created that. However the first and the last person in each group will show the appropriate background color. But all the persons inbetween will not show a color and just stays white. How do I fix that? (On the conditional formating I chose CELL VALUE IS BETWEEN. Should I do something else?)

Thanks for your help!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
L

Legacy 98055

Guest
I'm a VBA guy and am very hesitant to help a Steeler's fan (am from Cincy :)), but gave this one a shot because you did not have any replies. Instead of providing a long winded explanation, just see the download and take a look for yourself... :)

I Love The Bengals (28 to 20) Who Dey.zip
 

Forum statistics

Threads
1,136,266
Messages
5,674,727
Members
419,523
Latest member
Urnovio

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top