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

[ttt637]

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

============ and I want to look like this====

 

[bebo021999]

Nice to hear it works.

 

[ttt637]

I sure feel stupid right now but where is this located??

 

[bebo021999]

Stay in cell B2 while setting condition.

 

[ttt637]

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.