Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Similar Data in worksheets | Excel Discussion (Misc queries) | |||
Finding similar data in a spreadsheet | Excel Discussion (Misc queries) | |||
Finding the MAX number while considering similar names | Excel Discussion (Misc queries) | |||
Finding and Highlighting Similar but not Identical Cells in a Colu | Excel Discussion (Misc queries) | |||
Finding similar data or numbers in two columns | New Users to Excel |