highlight cell having top 3 values

[vinu9092]

in excel sheet i have values(percentage) in b31 to b41 and d31 to d41.from both columns I want to fill cell color having top 3 values. tried for two days but did not get result.

 

[Aladin Akyurek]

both columns needed to be selected before selecting TOP function and then ok

Row\Col	B​	C​	D​
31​	0.04%​	8500​	8.76%​
32​	595.81%​	8550​	60.53%​
33​	122.47%​	8600​	-4.19%​
34​	674.30%​	8650​	-44.90%​
35​	90.76%​	8700​	-55.35%​
36​	40.38%​	8750​	-34.41%​
37​	34.70%​	8800​	-42.76%​
38​	64.26%​	8850​	-15.25%​
39​	5.79%​	8900​	-27.58%​
40​	-5.73%​	8950​	-3.23%​
41​	-1.97%​	9000​	-46.19%​

Care to color this sample of yours manually, so it's clear if there is any dependency between the columns?

 

[vinu9092]

most value are negative on right side ,but this is just for example.regarding color 674.30 cell should have golden color,595.81 should have silver color and 122.47 should have yellow color. % keeps on changing .

 

[Aladin Akyurek]

most value are negative on right side ,but this is just for example.regarding color 674.30 cell should have golden color,595.81 should have silver color and 122.47 should have yellow color. % keeps on changing .

It seems I can't get to clarify whether any dependency between the columns. Neither did you color column D in order to help me out.

So:

CF
Select B31:B41
Implement the formula:

=$B31=LARGE($B$1:$B$41,1)

Implement the coloring.

Repeat this procedure with:

=$B31=LARGE($B$1:$B$41,2)

and with:

=$B31=LARGE($B$1:$B$41,3)

Good luck.