View Single Post
  #2   Report Post  
nbrcrunch
 
Posts: n/a
Default


You need to have each element (car name) in its own cell. You cannot use
conditional format to selectively highlight a portion of a cell.

The FIND() function can be used to write a formula that will put a
value in an adjoining cell if criteria is found for both, but not
conditional formatting.

For example, if cell A1 contains:
Ford, Chevy, Mazda

and cell B1 contains:
Chevy, Mercedes, Accord

You could have column C be your column for finding your matches of
Chevy, column D your column for finding matches of Ford, etc.

C1 formula could be:
=IF(AND(FIND("Chevy",A1,1),FIND("Chevy",B1,1)),"Ma tch","")


--
nbrcrunch