View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Conditional formatting for lowest number in a string

See conditional format for A1:A14 in: http://cjoint.com/?dxsgfobEPX

HTH
--
AP

"Phil Lewis" <Phil a écrit dans le message
de ...
I have a column of numbers and want to color highlight the lowest number

in
the column. However, I only want to color highlight if there is a clear
"winner". Ties should not activate the color. There is a posted article

on
the MS site (article 909845) using an IF statment but it does not allow

for
ties. Does anyone know how to do this.