Prev: vba or excel help
Next: Excel hyperlink within workbook and SharePoint drafts
From: Curt on 9 Apr 2010 12:39
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.
From: Luke M on 9 Apr 2010 13:04
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.

--
Best Regards,

Luke M
"Curt" <Curt(a)discussions.microsoft.com> wrote in message
news:3948F508-A7A7-42F1-8DB8-F1F5EC8FA681(a)microsoft.com...
>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.


From: מיכאל (מיקי) אבידן on 9 Apr 2010 13:20
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


"Curt" wrote:

> 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.
 | 
Pages: 1
Prev: vba or excel help
Next: Excel hyperlink within workbook and SharePoint drafts