excel for mac highlight cell if value exists in another column

If the text in Column A is contained within Column C, highlight that cell in column C.

I have tried to select the range for the entire column within conditional formatting, but it came up with an error.

Any insight on this particular issue would be great appreciated.

Formatting in C2 enter IF(ISERROR(MATCH(A2,C2:C13,FALSE)),0,1)1 and apply it to C2:C13 with your formatting colourfont etc.

Cell C4 shows as not being highlighted, but the remaining cells become highlighted.

The A4 cell with K1G is the only value that doesnt appear in column C, whereas all the other column A cells are to be found somewhere in column C.

If thats not what you want (which is suggested by your original post), then manually format the cells you want to see highlighted, explaining with a note as to why and upload the workbook again.

My apologies for that I should have been more clear in my post, I have formatted the table the way that I would like to have it look and re-attached it.

C4, C9 and C12 should not be highlighted because the value in A4, A9 and A12 does not appear in those cells.

So looking at it row by row, if the value shows in the A, and it shows in C, then highlight it.

Incidentally, when you have a moment may I suggest that you change your Excel version in your profile.

It didnt particularly matter in this case but it does often help when others are responding.

Had your question involved more than 3 conditional formats (the limit in 2003) then you might have limited the responses you may have received.

If by your example you mean it will always be the 2nd - 4th characters that you want to use then.

NOT(ISERROR(MATCH(MID(B2,2,3),C2,FALSE))) Id avoid the need to recognise cell or font characteristics, thats never straightforward.

Try and use some standard function (like a string slicing function) or some other helper cell function to identify the subject of the match.

The question now is, what if you want to ignore blanks (NULL) For ex, say this what I have 8063470 8063470 10245602 10245602 11061324 11064143 11064143 12029101 12029101 12997070 12997070 13685658 15606123 15606123 16533407 16533407.

Excel For Mac Highlight Cell If Value Exists In Another Column