conditional format smallest number

**grizzly6969** · 07-13-2010, 01:24 AM

This has been asked before but I have not seen a working answer
A2:M2 has numbers 1 through 10 - - - - I want the smallest none duplicate number to turn red
If there are two # 1 and a # 2 then 2 is the smallest number - - - - if there are two # 1 and two # 2 and no # 3 then # 4 would be the smallest number and be highlited red

**dan1402** · 07-13-2010, 02:00 AM

Please Login or Register  to view this content.

This make the smallest value red. In any selection.

**grizzly6969** · 07-13-2010, 02:25 AM

I copied your formula and inserted into my worksheet in module and nothing happened should I have pasted in different area

**DonkeyOte** · 07-13-2010, 02:31 AM

Originally Posted by grizzly6969

A2:M2 has numbers 1 through 10 - - - - I want the smallest none duplicate number to turn red

Highlight A2:M2 and apply a Conditional Format FormulaIs Rule of:

=IF(ISNUMBER(A2),A2=MIN(IF(COUNTIF($A2:$M2,$A2:$M2)=1,$A2:$M2)))
set format accordingly