I want to highlight the highest value in a row accross multiple columns, every other column contains the value I want to reference to obtain the MAX value:


A B C D E
S1 20 50% 30 70%
S2 30 60% 40 30%

I want to highlight the 70% because it is higher than the 20% and for store 2 I want to highlight the 60% because it is higher than 30%. I want to disregard the values in column B and D.