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

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

Sorry... MS Excel 2003.

thanks


"OssieMac" wrote:


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

Then I think that the only way to do this is with macro code. I haven't tried
but think I can handle it but first do you want that sort of answer? My
apologies because I should have said this in my previous post.

Excel 2007 handles it easily with conditional format but not earlier versions.

--
Regards,

OssieMac


"reza" wrote:


Sorry... MS Excel 2003.

thanks


"OssieMac" wrote:


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

I think i can use my boss notebook :D
can you explain how to create this??

thanks

"OssieMac" wrote:

Then I think that the only way to do this is with macro code. I haven't tried
but think I can handle it but first do you want that sort of answer? My
apologies because I should have said this in my previous post.

Excel 2007 handles it easily with conditional format but not earlier versions.

--
Regards,

OssieMac


"reza" wrote:


Sorry... MS Excel 2003.

thanks


"OssieMac" wrote:


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

Helo Reza,

I take it you mean how to create the conditional format in xl2007 so here it
is.

Firstly the easiest way to apply Conditional Format is to select the entire
range and apply the formula as if it applies to the first cell only. The
following examples look like they apply to cell A2 only but Excel actually
applies it to all the cells in the selection.

Ensure that Home ribbon is selected.
Select the full range of percentages involved.
Select Conditional Format (See Styles block just past half way across ribbon)
Select Manage Rules.
Click New Rule.
Select €˜Use a formula to determine which cells to format.

In the field below €˜Format cells where this formula is true enter the
following formula where A2 is the first cell in the selection and $A$2:$A$30
is the entire range to which the Conditional format is to be applied. (You
can select the range on the worksheet to insert it as you can do in the
formula bar on a worksheet. Also note the absolute addressing of the range
but not for cell A2.)

=A2=LARGE($A$2:$A$30,1)

Click Format button.
Click the Font or Fill tab at the top depending on whether you want to
change the font or background colour.
Select Yellow.
Click OK and OK again.
Click Apply.
That has added the Conditional Format for the highest value.

Click New Rule.
Repeat the above but this time the formula is for the second highest value
as follows. (Note the parameter 2 in lieu of 1 in the previous formula).

=A2=LARGE($A$2:$A$29,2)
Set Format to Green colour.

Repeat the above again with the formula.
=A2=LARGE($A$2:$A$29,3)
Set format to Blue colour.

Repeat the above again with the formula. (Note parameter 1 is the smallest
value)
=A2=SMALL($A$2:$A$29,1)
Set format to Red colour.

Ensure you click Apply before closing the Conditional Format dialog box.

Hope I have explained it all properly but feel free to get back to me if you
have problems.


--
Regards,

OssieMac