View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mpenkala mpenkala is offline
external usenet poster
 
Posts: 90
Default Highlight a max number

hey gang,
easy one here (I'm assuming).

ColAO contains 18 numbers, from AO3-AO20. The numbers change constantly
while I input data. How can I make the current high number change color? I
know it with conditional formatting, but can't seem to get the formula
correct. Also - if 2 or more numbers are currently the highest, both should
be highlighted.

Thanks,
Matt