Conditional formatting - highlight the most similar number

Hi
Assuming you mean .5 and above goes to the next number, try this Conditional Formatting formula, as per the ranges in my previous formula:

=MATCH(MROUND($D$2,1),$F$2:$F$8)=ROW()-1

Hope this is more what you're after.
DBY

Hi DBY,

Thanks again for you post, but again, I am still struggling!

Is it possible to post up an example worksheet? And if so, how?

Cheers, Jon