Cell shading based on conditions

[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.

 

[Guest]

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