Can conditional formatting be applied to a 3D reference?

%3CLINGO-SUB%20id%3D%22lingo-sub-3323754%22%20slang%3D%22en-US%22%3ECan%20conditional%20formatting%20be%20applied%20to%20a%203D%20reference%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3323754%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20with%2020%2B%20worksheets.%20I%20need%20to%20apply%20conditional%20formatting%20to%20two%20columns%20on%2017%20(same%20layout)%20worksheets.%20Can%20I%20create%20conditional%20formatting%20and%20have%20it%20apply%20to%20a%203d%20reference%20without%20having%20to%20apply%20to%20each%20individual%20worksheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3323754%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3325982%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20conditional%20formatting%20be%20applied%20to%20a%203D%20reference%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3325982%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1382005%22%20target%3D%22_blank%22%3E%40TReigner%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20have%20to%20create%20the%20rule(s)%20for%20each%20sheet%20separately%2C%20one%20rule%20cannot%20apply%20to%20multiple%20sheets.%20It%20can%20%3CEM%3Erefer%3C%2FEM%3E%20to%20multiple%20sheets%20though.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3326715%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20conditional%20formatting%20be%20applied%20to%20a%203D%20reference%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3326715%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B.%20I%20was%20afraid%20that%20was%20going%20to%20be%20the%20answer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a workbook with 20+ worksheets. I need to apply conditional formatting to two columns on 17 (same layout) worksheets. Can I create conditional formatting and have it apply to a 3d reference without having to apply to each individual worksheet?

 

2 Replies

@TReigner 

You have to create the rule(s) for each sheet separately, one rule cannot apply to multiple sheets. It can refer to multiple sheets though.

Thanks @Hans Vogelaar . I was afraid that was going to be the answer.