View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Giselle[_2_] Giselle[_2_] is offline
external usenet poster
 
Posts: 22
Default code to highlight max value in a range

Range D2:D100 has several values and some blanks. I need a good way to
highlight the maximum value in this column and its matching value in column
C. I'd like to highlight them red and bold.

I need CODE, NOT formulas in the cells since there are already formulas in
the cells.

much thanks far any assistance
Giselle