I have a list of numbers and i need to either highlight (using conditional
formatting)or display in another cell the nearest number under 10000

i.e

9854
9752
11254
10987
9974 <---------
10025

Help!!!!!