Ask Your Question

Need to Sort Data by Background Color in Calc [closed]

asked 2017-06-07 04:54:12 +0200

Dhanson gravatar image

updated 2020-08-06 22:26:10 +0200

Alex Kemp gravatar image

Pretty much what I need to do here is sort data in rows based on their background color- for example, I have a bunch of red, yellow, green, and blue data in column C but need to sort all the reds into column D, column E, etc. while still locking their rows. Is there a command to do this? Thanks for help.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-06 22:26:54.016502


Could you provide a bit more detail? Are the cells colored using conditional formatting?

Is this a spreadsheet that you have made yourself? If so, have you considered that it may not be a good idea to let calculation depend on formatting?

hjek gravatar imagehjek ( 2018-05-18 02:37:06 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-06-07 08:34:47 +0200

komma4 gravatar image

Assuming you didn't apply cell styles to set the background colors: No, there is no built-in solution (command).
You have to use a (customized) macro for that.

edit flag offensive delete link more


Thanks for the response. Do you know the location of a functional macro download that can do the trick?

Dhanson gravatar imageDhanson ( 2017-06-07 17:30:25 +0200 )edit

If so, I would have posted it. Never bothered to write a macro like that, because I always work with styles, which makes this fumbling expendable.

komma4 gravatar imagekomma4 ( 2017-06-07 18:14:53 +0200 )edit

"fumbling expendable?" It's a standard Excel feature, so it's popular and worthwhile.

Dave S gravatar imageDave S ( 2018-03-21 04:52:06 +0200 )edit

Question Tools

1 follower


Asked: 2017-06-07 04:54:12 +0200

Seen: 4,114 times

Last updated: Jun 07 '17