What version of excel are you using?

--
Regards,

OssieMac


"reza" wrote:

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