May 05 2022 07:02 AM
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?
May 05 2022 08:57 AM
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.
May 05 2022 10:18 AM
Thanks @Hans Vogelaar . I was afraid that was going to be the answer.