View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default Conditional Formatting Minimim Value

Selecting cell A1, CF formula is:
=AND(A1=MIN($A1:$A10),COUNTIF($A1:$A10,MIN($A1:$A1 0))=1)

Copy across to apply to cells A1:A10, copy down as needed.

--
Best Regards,

Luke M
"Curt" wrote in message
...
I would like to have conditional formatting for the minimum value in a
range.
I only want to format the minimum value if only one cell has that value.

Here is the formula to check if there is only one minimum value:

=IF(COUNTIF(A1:A10,MIN(A1:A10))=1,TRUE,FALSE)


For example,

data set (4,5,5,5,5) format cell with "4"

data set (4,4,5,5,5) do not format any cells.