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!!!!