Forum Discussion
How to get cells to copy other cells on colour alone?
My exact situation: A1 is conditional formatted to turn green when text appears “work” I wish for A2 to turn green just because A1 did WITHOUT the text following or being needed it see...
mtarler thank you, I had a Reddit post give a similar answer and it gave what I wanted
As a follow up do you know if it’s possible to get a sum number by colour alone without vba?
It’s the last piece for me, to get an automated tally of the scores of each colour alone in top right
thanks 🙏
You can't use sheet formulas to differentiate cell colors BUT since the colors are based on conditional formatting you can certainly create a formula that uses that same logic to find the sum.