Need help using an IF statement with conditional formatting

[thinmints88]

I am looking to highlight cells in a column only if the values of the cells in the neighboring column are greater than or equal to a certain number. Additionally I am only looking to highlight the 10 smallest numbers in the column. For example:

Highlight the 10 smallest values in column A only if the values in column B are greater than or equal to 5.

Is this possible? Thank you!!!

 

[FDibbins]

I dummied up a sample for you, but I only used 10 numbers, so I restricted it to the bottom 5, rather than the bottom 10 - just change the bolded value
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][/tr]
[tr][td]

1​

[/td][td]

1​

[/td][/tr]

[tr][td]

2​

[/td][td]

2​

[/td][/tr]

[tr][td]

3​

[/td][td]

3​

[/td][/tr]

[tr][td]

4​

[/td][td]

4​

[/td][/tr]

[tr][td]

5​

[/td][td]

5​

[/td][/tr]

[tr][td]

6​

[/td][td]

6​

[/td][/tr]

[tr][td]

7​

[/td][td]

7​

[/td][/tr]

[tr][td]

8​

[/td][td]

8​

[/td][/tr]

[tr][td]

9​

[/td][td]

9​

[/td][/tr]

[tr][td]

10​

[/td][td]

10​

[/td][/tr]
[/table]
If you are familiar with CF, ignore the 1st 2 points
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A1<=SMALL(IF($A$1:$A$10<=5,$A$1:$A$10),5)...Format Fill your color choice