CODEWITHSUNDEEP
google-sheetsgs-conditional-formatting
Dana Smith
Dana Smith

Reputation: 1

Conditional Format a column based on rest of rows in that column

I'm trying to conditional format Column B based on if rows C thru X have the word OPEN in them or not.

Upvotes: 0

Views: 52

Answers (1)

pnuts
pnuts

Reputation: 59495

@user3616725 makes some very relevant points in the comment but I am guessing OPEN fills a cell or does not count and that anywhere in C through X would be the trigger, so please try: 

=countif(B1:X1,"OPEN")>0

for Custom formula is in Format, Conditional formatting... with formatting of your choice applied to Range B:B.

Upvotes: 1

Related Questions