Finding Similar Data
Hello,
I would like to set conditional formatting to highlight the data value from
five different columns that is most similar to another data value in a sixth
column (there will be one data point between all of the five columns that is
closest to the sixth column). I would then like to sort the data based on
the similarities. I don't know if there is a way for conditional formatting
to pick out the closest value---if this is possible, please let me know!
Thanks for any help you can provide.
|