You can use a formula. If you want to highlight B1 if it contains a value
that appears in C15, use the formula =B1=C15. B1 will have to be exactly
equal to C15. If it is, the formula returns TRUE else FALSE. Then select the
formatting you want.

Tyro

"David in VB" wrote in message
...
I have Excel 2007 and for some reason I can't get started on Conditional
Formatting. For instance, I just want to highlight any cells that contain
values the appear in other cells. I assumed this was "highlight duplicate
cells" but I can't find where to plug in the range or tell Excel what
columns
to search.

I'd like to ask if anyone can tell me how to make the above formatting
happen. Thanks! I really appreciate it.