Thread: If I have a colunm of numbers, can I format to highlite the smalle
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default If I have a colunm of numbers, can I format to highlite the smalle
Try this:

Assume your numbers are in the range A1:A5
Select the range A1:A5
Goto FormatConditional Formatting
Formula Is: =AND(A1<"",A1=MIN(A$1:A$5))
Click the Format button
Select the style(s) desired
OK out

Biff

"Dr. Darrell" wrote in message
...
If I have a colunm of numbers, can I conditionally format to highlite the
smallest value in the colunm?


Reply With QuoteReply With Quote