Ask Your Question
0

Conditional format

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

_dave gravatar image _dave
21 4

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

delete close flag offensive retag edit

2 Answers

Sort by » oldest newest most voted
0

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

Pedro gravatar image Pedro flag of Portugal
3343 4 26 56

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

link delete flag offensive edit
0

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

mariosv gravatar image mariosv flag of Spain
5039 23 51

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

link delete flag offensive edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

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

Seen: 213 times

Last updated: May 20 '12