View Single Post
  #2   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

Apply conditional formatting to your range (named TheRange) and use the
following condition to show the selected item in a different color:

=ABS(A1-(0.25*MAX(TheRange)))=MIN(ABS(TheRange-(0.25*MAX(TheRange))))

assuming the column starts in A1.

--

Vasant



"feman007" wrote in message
...
I'm trying to find the closest value in a column to a specified number,

then
list it. Basically, I have a function in which I have to find 25% of the

max
value and find which value in the data column that is closest. I was

trying
to use a function to search the column but it wasn't working. any

thoughts?

Thanks,
Dave