Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Minimim Value
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Minimim Value
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$1 0))=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |