in excel conditional formatting find the greatest value in 4rows

in excel conditional formatting i want to find the greatest value in a column
and change its colour

Hi!

Suppose the numbers are in the range A1:D5

Select the range A1:D5
Goto Format>Conditional Formatting
Formula is: =A1=MAX($A$1:$D$5)
Click the Format button
Select the style(s) you want
OK out

Biff

"prac g" <pracg@discussions.microsoft.com> wrote in message
news:CF94EFF3-0E02-4D10-B4DA-58423AC5E4F2@microsoft.com...
> in excel conditional formatting i want to find the greatest value in a
> column
> and change its colour