Conditional Formatting match text in a string

[mrxlsx]

Good evening all,

I have a column named Remarks. I want to apply conditional formatting for those cells which have the following text strings in that. How to do this ??

1. Cancel
2. Cancelled
3. Invoice Cancelled
4. Invoice got Cancelled


Thank you

 

[Joe4]

If you are looking for any phrase that has the word "Cancel" in it, you can use a Conditional Formatting formula like:

=ISERROR(FIND("Cancel",A1))=FALSE

 

[mrxlsx]

Hi Joe4,

Thanks for your effort, that's really nice, can you make that work without case sensitivity ??

 

[Joe4]

Replace the "FIND" function with "SEARCH", and it should do the trick.
FIND is case sensitive, SEARCH is not.

 

[mrxlsx]

Hey Joe,

That is a nice solution. Thanks and God bless you.

mrxlsx