0

I'm looking to recolor cells in a Sheets document I have, simply based on the original color that the cell already has. This is regardless of the contents of the cell and doesn't follow a traditional pattern such as alternating or by simple blocks of color. Is there any way to simply make it work like for example, change all cells currently colored green to the color red? Some of the cells are empty but I'm trying to basically change the colors without having to select every block of cells individually.

2
  • Isn't the original color given by conditional formatting? (by pure chance)
    – Daniele
    Commented Jun 8, 2022 at 19:08
  • If your data is in a table format, you can sort your entries by color, which would make it easier to select all your data, and recolor manually.
    – Oren
    Commented Jun 9, 2022 at 20:21

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.