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
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