Hi Mike,

copying onto another area of the Sheet say E1:
Your original table:
A B
1 name score
2 name1 4
3 name2 5
4 name3 3
5 name4 6
6 name5 7
7 name6 6

Above your original table place these new rows getting the following table:
1 name score
2 <5
3 name score
4 name1 4
5 name2 5
6 name3 3
7 name4 6
8 name5 7
9 name6 6

Fill in the Custom filter dialog box as follows:
Check Option button Copy to another place
List range: $A$4:$B$10 (place the cursor in the field and select these
cells)
Filter range: $B$1:$B$2 -"-
Copy to: $E$1 -"-
Click OK

conditional formatting to bring the original columns to a say Blue colour if
they make the <+5 criteria.

Select range A5:B9
Bring up Conditional formatting

Select Formula (on the left side of the box)
Type =$B5<5 as the formula
Select a color
Click OK

Regards,
Stefi