Search:

Thanks JB... that works great.

Got it with the use of helper columns.

Used MOD function to separate the whole number.
Used MIN function to find the lowest.
Then conditional format to highlight.

If someone has a solution...

I would like to highlight it.

2.45
3.75
2.08
4.06


Need formula that would choose 4.06 from above list.
Even though it is the largest number, the .06 is closest to the whole number.