highlight cells based on another cells

[jo206]

hey guys

I've been looking for this for a while but haven't had much luck

I know that in order to highlight cells based on another cell you go something like =$a1="xyz" but in my case I have a lot of cells with long text values so adding one by one will be troublesome.

so I have
-Sheet 1 where I constantly copy,paste and delete job posts with different companies under Col A
-Sheet 2 where I keep adding names of companies under Col A. Currently I have about 20 names here and there will be more.

What I am looking for is whenever I paste data into Sheet 1 I want cells to be highlighted if those companies are found on Sheet 2.

is there an easy way to build this?

Thanks in advance!
J

 

[Anonymous1378]

=COUNTIF(Sheet2!$A$1:$A$100,Sheet1!$A1) for an applies to area of A:A I guess?

 

[jo206]

=COUNTIF(Sheet2!$A$1:$A$100,Sheet1!$A1) for an applies to area of A:A I guess?

worked like magic, thank you!