Hi
if your data is in A1:A10 try the following:
- select this range
- goto the conditional format dialog
- enter the following formula:
=RANK(A1,$A$1:$A$10,TRUE)+COUNTIF($A$1:$A1,A1)-1<=2
- choose your color

--
Regards
Frank Kabel
Frankfurt, Germany

"Putty" schrieb im Newsbeitrag
...
I would like to highlight data using Conditional Formatting from a
list of
numbers but only want to highlight the 2 smallest numbers.

E.g. Data list = 6,7,8,1,9,2,4,2

The result should highlight the number 1 BUT ONLY THE FIRST 2 - I
don't want
both 2s highlighted.

Thanks,