Conditional Formatting

[toddp2]

Hi

Is there a way to conditional format multiple sheets at the same time anytime I try the conditional format option is greyed out.

thanks
toddp2

[NickyC]

hi
I don't think there is
you could copy the first sheet and use format paster to paste onto the other areas
or, you could use a macro to speed up formatting several sheets, if there are lots of them