Hi all. Hopefully a simple one!
I have two columns of names, a third column has a simple IF statement that generates a YES if the two names in the same row are the same. So far so easy.
I have another sheet in the same WB with another long list of names. What I can't figure out is how to highlight the cell that contains names on the 2nd sheet that have generated a YES on the first sheet. I'm hoping someone will tell me how simple it is!
Thanks for any assistance guys & girls....
Bookmarks