Check out Conditional Formatting in XL Help. One way:


Select A1:C1. Choose Format/Conditional Formatting. Set the dropdowns
and textbox to read

CF1: Formula is =A1=MAX($A$1:$C$1)
Format1: Patterns/<highlight color



In article ,
"Tbentsen" wrote:

Is there a way in which you can make Excel mark the higest number in a row or
column?

Example:

A B C
1 1 3 2

In this example, I would like the cell B3 (or the text in the cell)
automatically highlighted, as it being the higest value of the three cells
A1:C1

Is this possible?