CF/ Cell value is/ Equal to/ =MAX(A$1:A$11)
Select your highlighting format.
--
David Biddulph

"kimmy2003" wrote in message
...
I want the highest number in the below range of numbers to highlight in a
different color no matter how many times it changes. How can I do that?

$3,485.00
$475.00
$100.00
$1,190.00
$4,245.00
$- 0
$3,277.00
$10,035.00
$- 0
$2,930.00
$- 0