View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kimmy2003 kimmy2003 is offline
external usenet poster
 
Posts: 2
Default Conditional Formatting

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