Conditional Formatting Help

[DRExcel515]

Is it possible to have a conditional format rule on a cell based on whether or not in column M it says "Break". Basically if the text anywhere in column "M" says Break that cell should be conditionally formatted. Any help would be much appreciated.

Thanks!

 

[Scott T]

This should work in conditional formatting

=COUNTIF(M:M,"break")>0

 

[DRExcel515]

Thanks @Scott T that works great. I was trying something similar but had it set up slightly different.