Ask Your Question

clone color from one cell to another

asked 2019-05-27 15:58:49 +0200

needsleep gravatar image

I wish to copy the color of a cell to another cell. If I use clone format, it copies things like number format, text format, etc. I just want the color copied over. Is there a fast way to do this?

I've been doing this manually, like so: If the highlighter tool is not already showing the color of interest, I click on the cell with the color I want. I then open up the highlighter tool and it shows me where the current color is located within its matrix of colors. I click on the color its showing me to transfer that color to the default color displayed on the tool when its not open. I then place the cursor in the cell where I want the color to change, and hit the highlighter tool to grab its default color. This preserves whatever format the cell had (number, text, etc.), while just changing the highlighting color to the one of interest.


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-05-27 17:21:37 +0200

ebot gravatar image

updated 2019-05-27 17:25:16 +0200

This is best achieved with a cell format.

image description

You mark your cell. Then double click on the desired cell format.

If my answer did solve your problem, please click the big checkmark inside the circle image description to the left of this answer. It then indicates to the other participants that the question has been answered correctly.

edit flag offensive delete link more


With me Windows 10 Home; Version 1809; 64-Bit | LibreOffice, Version: (x64).

ebot gravatar imageebot ( 2019-05-27 17:23:01 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-27 15:58:49 +0200

Seen: 17 times

Last updated: May 27