Hi all

I have the following 3 problems on hand.

1st problem:

My formulas are as follows to return the 2nd highest and 3rd highest value from the following set of data. I need the result to show me the 2nd and 3rd highest value but ignoring duplicate values.
= LARGE (A1:A13,2). Result is 370. I want the result to be 339
= LARGE (A1:A13,3). Result is 370. I want the result to be 300

300
300
339
370
250
200
138
138
250
370
370
125
150



2nd problem:

I need to do conditional formatting for the 1st lowest and 2nd lowest value for the following set of data. My formula is:
=MIN(C1:C10). I want the result to show that all the number "1" is highlighted. This formula is currently working correctly.
=SMALL(C1:C10,2). I want the result to show that all the number "3" is highlighted as the 2nd lowest value. This formula is not working correctly and does not conditional format if there is more than one "1" in the data.

11
3
5
4
11
1
1
3
5
1

thanks all in adv for your help!