Conditional formatting - colored symbols

Closed
roberto - Dec 20, 2009 at 08:15 PM
lfefil Posts 60 Registration date Monday December 21, 2009 Status Member Last seen December 25, 2009 - Dec 24, 2009 at 10:56 AM
Hello,
I have a range of scores which are the following:
green < 36%
yellow 36 - 50%
orange 51 - 75%
red > 75%

What I want to happen in Excel is to have colored symbol. i.e. a small circle like a bullet that fits a single cell, that shows the color status of the category. Let's say there are 5 categories: order, cleanliness, punctuality, organization, honesty.
If the Order catefory score is less than 36%, the green bullet or circle appears beside it, i.e cell to the right. If the Cleanliness category score is greather than 85%, the red bullet or circle appears and so forth.
Thus it will look like this.

Cleanliness - red bullet (this should be symbol not the words red bullet)
Order - green bullet (this should be symbol not the words red bullet)
etc.

I'm no Excel expert nor a programmer. Your help is much appreciated.
Thank you.

1 response

lfefil Posts 60 Registration date Monday December 21, 2009 Status Member Last seen December 25, 2009 10
Dec 24, 2009 at 10:56 AM
it sound siple when you are doing conditional formating just change the font and use simbol as yu like to give. and change the color. i think it may work
1