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]

Select B31:D41, copy the selection, and post it here.

 

[vinu9092]

Select B31:D41, copy the selection, and post it here.

b	c	d
0.04%	8500	8.76%
595.81%	8550	60.53%
122.47%	8600	-4.19%
674.30%	8650	-44.90%
90.76%	8700	-55.35%
40.38%	8750	-34.41%
34.7%	8800	-42.76%
64.26%	8850	-15.25%
5.79%	8900	-27.58%
-5.73%	8950	-3.23%
_1.97%	9000	-46.19%

<tbody>
</tbody>

highest value should be selected from column B and column D(i.e b31:b41 and d31:d41)

 

[vinu9092]

b	c	d
0.04%	8500	8.76%
595.81%	8550	60.53%
122.47%	8600	-4.19%
674.30%	8650	-44.90%
90.76%	8700	-55.35%
40.38%	8750	-34.41%
34.7%	8800	-42.76%
64.26%	8850	-15.25%
5.79%	8900	-27.58%
-5.73%	8950	-3.23%
_1.97%	9000	-46.19%

<tbody>
</tbody>

highest value should be selected from column B and column D(i.e b31:b41 and d31:d41)

0.04%	8500	8.76%
595.81%	8550	60.53%
122.47%	8600	-4.19%
674.30%	8650	-44.90%
90.76%	8700	-55.35%
40.38%	8750	-34.41%
34.70%	8800	-42.76%
64.26%	8850	-15.25%
5.79%	8900	-27.58%
-5.73%	8950	-3.23%
-1.97%	9000	-46.19%

<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

Great. thanks.

On a 2016 system...

Select the range in column B, activate conditional formatting. And run:

Top/Bottom Rules | Top 10 Items

Adjust the relevant box to 3 and choose the color you want in the adjacent box.

And repeat the foregoing procedure for the range in column D.

 

[vinu9092]

i want to compare both the columns simultaneously.i want to color first highest with golden color,second highest with silver color and third highest with blue color?

 

[Aladin Akyurek]

i want to compare both the columns simultaneously.i want to color first highest with golden color,second highest with silver color and third highest with blue color?

Not clear...

What is the dependence between two columns?

 

[vinu9092]

assume left hand side is volume of call option and right hand side percentage is volume of put option.we have to select highest volume from both columns.with TOP 3 conditional formatting and selecting both columns, it highlight top 3 values but in single color for all cells. i want different color for 1st, 2nd and third.

 

[Aladin Akyurek]

assume left hand side is volume of call option and right hand side percentage is volume of put option.we have to select highest volume from both columns.with TOP 3 conditional formatting and selecting both columns, it highlight top 3 values but in single color for all cells. i want different color for 1st, 2nd and third.

So what I proposed is ok except for coloring?

 

[vinu9092]

So what I proposed is ok except for coloring?

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