Copy conditional rules from a sheet to another sheet

[Robie]

Hi

Basically, I have two sheets with similar data (for some reason one sheet has stopped updating data and I have replicated the sheet rows in another sheet). The 'non-working' sheet has several conditional formatting rules which I need to replicate in the new working sheet. The rules are quite complex. Is there any way I can copy/apply the rules to the new sheet without re-entering them individually?

Thanks.
Robie

[HansV]

You can use the Format Painter for this purpose. Or copy the source range, then select the target range, click the lower half of the Paste button and select Formats or press R.

[Robie]

You can use the Format Painter for this purpose. Or copy the source range, then select the target range, click the lower half of the Paste button and select Formats or press R.

Perfect. Thank you so much Hans - you learn new things everyday. :)