I am trying to identify cells within a row that have a different value from the second cell in the row. (The first cell in the row represents the identifier) All the cells within the row should either have a blank (if there was no value linked to the identifier) or a set of RGB values separated by commas. I have tried a variety of MATCH, EXACT, Special - duplicate rows, type formulas but either the commas within the cells or the blanks are messing with the formulas. Please let me know if I need to clarify more. I have attached an example of my spreadsheet. (As you can see in row 2, J2 and K2 are different from B2, so ideally I would like these cells to be highlighted to point out the difference). Thank you in advance to whoever can help.
Bookmarks