Can conditional formatting be applied to a 3D reference?

Copper 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.