Thread
:
Conditional formatting for lowest number in a string
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
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.
Reply With Quote