Conditional forming with info on a different tab
Hi,
I’m working with an excel sheet with the titles (Column A), ISBNs (Column B), etc. on offer from a publisher. I’ve ran that list through my library catalogue and have gotten a list of ISBNs that we have in our collection and added that info to the second tab. I want to highlight the Titles & ISBNs on the first tab to indicate that we already purchase those titles. How do I do this conditional formatting?
Thanks!
Hi, I’m working with an excel sheet with the titles (Column A), ISBNs (Column B), etc. on offer from a publisher. I’ve ran that list through my library catalogue and have gotten a list of ISBNs that we have in our collection and added that info to the second tab. I want to highlight the Titles & ISBNs on the first tab to indicate that we already purchase those titles. How do I do this conditional formatting? Thanks! Read More