Cell shading based on conditions

B

Brad1982

It seems very simple to me but I have no clue how to do it.

I have a Name followed by a set of numbers

A1.......................b1.......................b2...........................b3
Joe.......................6.........................2............................26

What I would like to accomplish is for the highest number cell to be
shaded using a comparison of all numbers in that row.

In the chart above b3 and only b3 would be shaded.
 
F

Frank Kabel

Hi
- select for example B1:D1
- goto format - Conditional Format'
- enter the following formula:
=B1=MAX($B$1:$D$1)
- choose your format
 
Top