I want A1 on Sheet1 to change color based on specific text in cell B1 on Sheet2 or even different Book...is that even possible with custum formula?

Tnx in advance

P.S. =ISText(indirect("Sheet2!B1")) this is working but dosent matters what text i put in and i want it to be specific word.

1 Answer 1


Use Regexmatch instead of Istext :

=REGEXMATCH(indirect("Sheet2!B1"),"specific string to check")

The second argument of regexmatch is a regular expression so you can use operator like |,.,/ or escape them with \. Also be sure to pay attention at lower/upper case issues because it's case-sensitive.

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.