LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 88
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell coloring Peter Excel Discussion (Misc queries) 3 February 8th 09 11:15 PM
Compute a rating of a mtd average compared to a rating scale reddy Excel Discussion (Misc queries) 0 January 12th 09 06:33 PM
coloring a cell if blank Karenobrn Excel Worksheet Functions 5 August 18th 08 10:15 PM
Cell Coloring supersub15 Excel Worksheet Functions 2 October 26th 07 04:12 PM
conditional cell coloring phrodude Excel Discussion (Misc queries) 5 July 27th 06 04:26 PM


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"