1

To be specific, I want when I enter box C1 with a value like "done" both cell B and C will be colored green. For this I already did =$C1="done"

Tho this time I want it to change color when it contains the text "drive" since it's a box where a person will link their drive file.

1 Answer 1

2

There are many ways to do this. Here are two of the most common:

=ISNUMBER(SEARCH("drive",$C1))

=REGEXMATCH(LOWER($C1),"drive")

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.