Conditional Formatting Minimim Value

C

Curt

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.
 
L

Luke M

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

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

מיכ×ל (מיקי) ×בידן

For range A1:A10
Select the range and CF as per the formula:
=AND(A1=MIN(A$1:A$10),COUNTIF(A$1:A$10,MIN(A$1:A$10))=1)
Micky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top