Ask Your Question

Calc Find & Replace format [closed]

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

anonymous user


updated 2013-06-10 20:44:24 +0200

manj_k gravatar image

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?

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-18 02:28:16.770462

1 Answer

Sort by » oldest newest most voted

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

rl gravatar image

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.

edit flag offensive delete link more

Question Tools


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

Seen: 1,165 times

Last updated: Sep 18 '12