Ask Your Question

Conditional format [closed]

asked 2012-05-20 04:23:44 +0200

_dave gravatar image

How do I transfer conditional formats from one worksheet to another?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 03:54:13.904321

2 Answers

Sort by » oldest newest most voted

answered 2012-05-20 17:10:00 +0200

Pedro gravatar image

Copy the cell with the Conditional formatting, switch to the target worksheet, select the cells to be formatted and choose Edit, Paste Special. On the Selection section uncheck all boxes except for the Formats.

It is obviously a bug (or a missing feature...) that the Format Paintbrush doesn't work between two open Worksheets...

edit flag offensive delete link more

answered 2012-05-20 17:10:15 +0200

m.a.riosv gravatar image

You can do it with copy/paste, if you only want to transfer the format then Meny/Edit/Past special/ and select only Formats.

edit flag offensive delete link more

Question Tools


Asked: 2012-05-20 04:23:44 +0200

Seen: 353 times

Last updated: May 20 '12