If I have a number in cell A1 on a tab called "start" and I want to see if that number appears anywhere else on a different tab, Is there a faster way for me to do this than using "OR" for each sell I want it to look at?
How would I use that formatting in conditional formatting. I dont want to count how many times it appers, rather have the cell highlight if it does appear somewhere or remain unhilighted if it doesn't appear.
Almost there, but you can't reference another worksheet in conditional formatting. I have tried defining the range Sheet2!A1:Z10 as Data and then referencing Data at both points in the forumula where you mention Sheet2, but I get a #VALUE! Error?