Conditional formatting - colored symbols

[Closed]
Report
-
Posts
60
Registration date
Monday December 21, 2009
Status
Member
Last seen
December 25, 2009
-
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 reply

Posts
60
Registration date
Monday December 21, 2009
Status
Member
Last seen
December 25, 2009
10
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month