Conditional Format: Highlight an Entire Column if value exists in another cell

Hi,

Using the Formula option in Cond. Formatting in C2 enter
=IF(ISERROR(MATCH(A2&"*",$C$2:$C$13,FALSE)),0,1)=1
and apply it to C2:C13 with your formatting colour/font etc.

Hello,

Thanks for the assistance, I appreciate it. I have applied the formula and selected the range of cells, but I am only getting one of the cells to show up as not being highlighted. Cell C4 shows as not being highlighted, but the remaining cells become highlighted.

Hi

That's indeed what I thought you were wanting. i.e. if any of the values in column A are found in column C then highlight the cell in column C.
The A4 cell with K1G is the only value that doesn't appear in column C, whereas all the other column A cells are to be found somewhere in column C.

If that's 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.

Regards

Hi,

OK, in that case

=NOT(ISERROR(MATCH(A2&"*",C2,FALSE)))

in C2 and applied to C2:C13

Thank You!!! Awesome!, I appreciate the help!

Is it possible to now sort these rows so that the non-highlighted cells appear at the top?

Hi,

OK, glad to have been able to help.

Incidentally, when you have a moment may I suggest that you change your Excel version in your profile. When I saw your first post I was about to switch on Excel 2003 until I realised that you have at least Excel 2007. It didn't 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.

Hi,

I don't know of a way for an Excel standard function to find and use bold characters from a string. You'd need a macro or user defined function for that. 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)))

I'd avoid the need to recognise cell or font characteristics, that's 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.