How do I highlight the 2nd and 3rd highest values in a ROW in Excel?

ttt637

New Member
Joined
May 7, 2022
Messages
7
Office Version
  1. 365
Platform
  1. Windows
I know how to find the min and max, but for the life of me I need to conditionally format some data output for work and can't for the life of me find out how to make the 2nd highest value AMBER and the 3rd highest ORANGE.

Example
1651922699388.png
============ and I want to look like this====
1651922783152.png
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
TY for the help but this is not working. What does the 14,6 represent?

What I am trying to do is take the 4 values in cells (for example) b4, I4, P4, and W4 and format them in 4 colors to show rank. there are other values in the other cells between them also. I have used excel for 20 years and I cant believe this is so hard to do.
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,185
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top