Hai Again,
I am trying to highlight first 3 highest values through conditional formatting but unable to do that.
Can some 1 help to apply conditional formatting.
I have a values in columns B-E and i applying formula in conditional formatting as mentioned below:-
1st highest values Blue: =B2= MAX($B2:$E2)
2nd highest values Green:=C2 = LARGE($B2:$E2,2)
3rdst highest values Red:=B2 = MIN($B2:$E2)
Copy of workbook is attached for your reference.
Bookmarks