Home

Cell Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-782925%22%20slang%3D%22en-US%22%3ECell%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782925%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20building%20multiple%20worksheets%20that%20are%20linked%2C%20and%20I%20am%20trying%20to%20get%20the%20same%20conditional%20formatting%20applied%20to%20one%20cell%2C%20to%20another%20cell%20(with%20the%20same%20value%20using%26nbsp%3B%20%3DF10%20)%20in%20another%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20pick%20up%20both%20the%20cell%20value%20and%20the%20formatting%20(fill%20colour).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ESimon%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-782925%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782986%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782986%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385415%22%20target%3D%22_blank%22%3E%40SimonF23%3C%2FA%3E%3C%2FP%3E%3CP%3EYou%20can%20do%20this%20using%20formula%20that%20can%20evaluate%20to%20TRUE%2FFALSE.%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20you%20could%20upload%20a%20sample%20file%26nbsp%3B%20with%20reastic%20data%2C%20you%20might%20be%20able%20to%20get%20better%20solution.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
SimonF23
Occasional Visitor

Hi,

 

I am building multiple worksheets that are linked, and I am trying to get the same conditional formatting applied to one cell, to another cell (with the same value using  =F10 ) in another workbook.

 

Is there a way I can pick up both the cell value and the formatting (fill colour).

 

Thanks

Simon

1 Reply

@SimonF23

You can do this using formula that can evaluate to TRUE/FALSE. 

if you could upload a sample file  with reastic data, you might be able to get better solution.