Conditional formatting - colored symbols

Closed
roberto - 20 Dec 2009 à 20:15
lfefil Posts 60 Registration date Monday 21 December 2009 Status Member Last seen 25 December 2009 - 24 Dec 2009 à 10:56
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 21 December 2009 Status Member Last seen 25 December 2009 10
24 Dec 2009 à 10:56
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