Conditional formatting across sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1472092%22%20slang%3D%22en-US%22%3EConditional%20formatting%20across%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1472092%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I'm%20trying%20to%20persuade%20excel%20in%20Office%20365%20to%20do%20some%20conditional%20formatting%20using%20two%20sheets%20but%20struggling%20to%20find%20out%20how.%20I'd%20be%20grateful%20for%20any%20advice!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%202%20sets%20of%20sheets%2C%20A%2CB%2CC%20and%20X%2CY%2CZ%2C%26nbsp%3B%20All%20of%20the%20sheets%20contain%20lists%20of%20words%3B%20sheets%20A%2C%20B%20and%20C%20have%20additional%20columns%20with%20numerical%20data%20in.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20excel%20to%20check%20the%20list%20of%20the%20words%20in%20sheet%20A%20against%20those%20in%20sheet%20X%3A%20where%26nbsp%3B%20a%20word%20from%20sheet%20A%20appears%20on%20sheet%20X%20(anywhere%20on%20the%20list)%2C%20I'd%20like%20it%20to%20put%20an%20X%20in%20next%20to%20the%20word%20in%20sheet%20A%2C%20in%20a%20new%20column.%20Then%20I%20need%20to%20set%20it%20to%20go%20through%20the%20same%20process%20for%20sheets%20Y%20and%20Z.%20Then%20I%20need%20to%20check%20sheets%20B%20and%20C%20in%20the%20same%20way.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20like%20it%20should%20be%20possible%20-%20but%20I%20just%20don't%20know%20how!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1472092%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1472418%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20across%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1472418%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F702693%22%20target%3D%22_blank%22%3E%40Lindsey540%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20hard%20to%20get%20an%20accurate%20picture%20(at%20least%2C%20to%20be%20sure%20it's%20accurate)%20from%20just%20a%20verbal%20description.%20Remember%20the%20old%20saw%20about%20a%20picture%20being%20worth....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20would%20it%20be%20possible%20for%20you%20to%20upload%20and%20post%20a%20representative%20sample%20of%20what%20you're%20trying%20to%20describe%3F%20The%20actual%20(rather%20than%20just%20an%20image)%20would%20save%20us%20from%20guessing%20and%20from%20having%20to%20re-create.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20sure%20there'll%20be%20many%20who'll%20be%20happy%20to%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi! I'm trying to persuade excel in Office 365 to do some conditional formatting using two sheets but struggling to find out how. I'd be grateful for any advice!

 

I have 2 sets of sheets, A,B,C and X,Y,Z,  All of the sheets contain lists of words; sheets A, B and C have additional columns with numerical data in. 

I want excel to check the list of the words in sheet A against those in sheet X: where  a word from sheet A appears on sheet X (anywhere on the list), I'd like it to put an X in next to the word in sheet A, in a new column. Then I need to set it to go through the same process for sheets Y and Z. Then I need to check sheets B and C in the same way. 

 

It seems like it should be possible - but I just don't know how!!

 

Thanks in advance!

1 Reply
Highlighted

@Lindsey540 

 

It's hard to get an accurate picture (at least, to be sure it's accurate) from just a verbal description. Remember the old saw about a picture being worth....

 

So would it be possible for you to upload and post a representative sample of what you're trying to describe? The actual (rather than just an image) would save us from guessing and from having to re-create.

 

I'm sure there'll be many who'll be happy to help.