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