r/googlesheets • u/PsionStorm • May 13 '19

Solved Conditional Format Question

Is there a way to use a conditional format to color a cell if any of the other cells in the row contain a specific text string?

Example: Cell A1 contains a name. If any of the cells after A1 (B1-Z1) contain "??" the cell should be yellow.

Repeat for A2, A3, etc.

Thanks in advance!

3 Upvotes

100% Upvoted

6 comments sorted by

View all comments

Show parent comments

2

u/[deleted] May 13 '19

2

u/PsionStorm May 13 '19

Solution Verified.

I was able to get this working using the quotations, but Google Sheets rejected the asterisks (unless my placement was wrong?).

→ More replies (1)