=countif(a1,"*closed*")0
or
=isnumber(search("closed",a1))


Cheri wrote:

I want to create a conditional format that shades the cell if the cell
"includes" the word 'Closed'. Some cells merely contain 'Closed' but others
contain 'Closed due to...'

I want all the cells that contain the word 'Closed' in them. I am not sure
how to do this as the "Cell Contains" doesn't include that option and I can't
think of a formula that would do that, off the top of my head.

Can you help? Thanks!!!!

--

Dave Peterson