Conditional Formatting Rule

Copper Contributor

I am trying to change the cell colour in column F, if the data in column A contains (T&M) within it.  The wording in column A will be more than just (T&M) but tried wildcard and couldn't get it to work.  Can anyone help?

2 Replies

@CThomson_E 

=ISNUMBER(SEARCH("(T&M)",A1))

Maybe with this rule for conditional formatting. 

Thank you. That has solved my issue!