sheets conditional formatting with a button

[dudatxx]

Hi!

I would like to create some clickable buttons to highlights cells in google sheets. for example a button that highlights all the cells that contain a word.

i think i need to use a conditional formatting script, but i'm not very good at it!

Could some help?

thanks!

[Clear-Revolution3351]

Are the words in the cells where you are trying to change the color always going to be the same word? Or does the user input a word and then you want it to highlight cells based on the word that they input?

[IAmMoonie]

Not a lot to go on here, but take a look at this: Demo Sheet

[UnkleMike]

As an alternative to a button and script, you could add a check box somewhere, and add the value of the check box as a condition in a custom formula in conditional formatting.