Ask Your Question

Need to Sort Data by Background Color in Calc

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

Dhanson 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 close merge delete


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 +0100 )edit

1 Answer

Sort by » oldest newest most voted

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

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 +0100 )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 +0100 )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 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 2,972 times

Last updated: Jun 07 '17