Ask Your Question
1

Calc Find & Replace format

asked 2012-09-18 17:10:06 +0200

anonymous user

Anonymous

In Excel 2007, you can do a find and replace on a cells format(i.e. fill, font color, bold...). Is there a feature or macro that does this?

delete close flag offensive retag edit

1 Answer

Sort by » oldest newest most voted
1

answered 2012-09-18 18:52:09 +0200

rl gravatar image rl
156 3

The closes is probably in the "Find & Replace" dialog to click first "More Options" and then "Search for Styles".

This way you can replace one formatting style by another one.

Of course you have to define the new style first, if it doesn't exist. Just in case you don't know where to define styles: Format → Styles and Formatting.

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-09-18 17:10:06 +0200

Seen: 179 times

Last updated: Sep 18 '12