Ask Your Question

Changing background cell color to another in calc [closed]

asked 2013-07-05 23:00:30 +0200

Slaynie gravatar image

Need to change background color in a lot of cells from black to another color (cant do it 1 by 1). I can do it in excel (with replace tool), but if possible, I would like to do it in Calc. Is there any easy non-manual way to do it? (I'm talking about thousands cells without any connection to each other)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-03 08:30:06.229368


can't use mariosv's solution, because cells contain different content (no string to search for) and a lot of them are even empty, with only background color set

Slaynie gravatar imageSlaynie ( 2013-07-06 09:35:10 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-07-06 00:54:27 +0200

m.a.riosv gravatar image

With Ctrl+H (Menu/Edit/Find&Replace)

In Search for: enter the string.

Click Find All, this select all found cells.

You can use Ctrl+1 (Menu/Format/Cells) for call Format Cell box, select the desired background.

edit flag offensive delete link more

Question Tools


Asked: 2013-07-05 23:00:30 +0200

Seen: 1,356 times

Last updated: Jul 06 '13