Highlight the lowest number - only if it does not equal another va
Try this...
Select the range A1:A6
Goto the menu FormatConditional Formatting
Formula Is:
=AND(A1<"",A1=MIN(A$1:A$6),COUNTIF(A$1:A$6,A1)=1)
Click the Format button
Select the desired style(s)
OK out
--
Biff
Microsoft Excel MVP
"JJ2356" wrote in message
...
I want to highlight the lowest number in a range, only if that number does
not equal another number in the same range.
For instance, if in Cells A1:A6, the number 2 is the lowest number and all
other numbers are higher, I want the cell with the number 2 highlighted.
If in Cells A1:A6, the number 2 is the lowest number, but occurs twice, I
do
not want any cells highlighted.
Any advice?
|