Conditional Formatting Question

Using SEARCH implies that "Closed" or "Resolved" might be amongst other text, in which case you could use this formula in conditional formatting

=COUNTIF(X1,"*resolved*")+COUNTIF(X1,"*closed*")

If "Closed" or "Resolved" would be the only word in the cell then the above would work but you only need

=OR(X1="Closed,"X1="Resolved")

Hi martin, thanks for the quick feedback.

I used the indirect function as seen it in another example online. I am applying the formatting to all cells at the same time (Ctrl & A before selecting conditional formatting) so it worked well for me.

I have attached a working example, as you can see the closed rows are blue but I need to get the moved rows to change as well...

Appologies if I am missig something, I have very little experince with this sort of thing.

Thanks

Dave

If you select the whole sheet you can use these conditions

=SEARCH("open",$X2)

=SEARCH("resolved",$X2)

=COUNTIF($x1,"*closed*")+COUNTIF($x1,"*moved*")

Note the $ which ensures that formatting is applied to the whole row, see attached

Yip, thats it! Thats Daddy... and Martin for your input.

Daddy your solution works fine, thanks.

For the record I was also able to update my own formula based on your suggestion (in case anyone finds it useful)...

=COUNTIF(INDIRECT("X"&ROW()),"*closed*")+COUNTIF(INDIRECT("X"&ROW()),"*moved*")

However I stuck with your suggestion.

Either way works, so I am happy. Thanks.

How can i do this
A1 has the word SUNDAY, if today's date is SUNDAY then A2 should return the word TODAY