Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create rating with coloring cell
HI Guys...
I have data which everyday will change. from that data i want to create rating for each items. for example A = 0.13% B = 1% C = 2.3% D = 1.2% E = 0% F = 2.1% , so on Based on that data, i want 3 of highest and lowest percentage will have different color. So C = Blue , F =Yellow, D = Green and the lowest E = Red. Since the percentage everyday will get updated so they will change it. How to archive that.... need to hear your explanation. and thank in advance reza |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell coloring | Excel Discussion (Misc queries) | |||
Compute a rating of a mtd average compared to a rating scale | Excel Discussion (Misc queries) | |||
coloring a cell if blank | Excel Worksheet Functions | |||
Cell Coloring | Excel Worksheet Functions | |||
conditional cell coloring | Excel Discussion (Misc queries) |