Conditional Format Formula "includes"
 

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

Conditional Format Formula "includes"
 

=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

Conditional Format Formula "includes"
 

If you scroll right to the bottom of the list, you get an option for
Contains.

Martin

http://homepage.ntlworld.com/martin.rice1/


--
mrice
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532738

Conditional Format Formula "includes"
 

You sure you're not thinking of Data|filter|autofilter, then custom filter.

mrice wrote:

If you scroll right to the bottom of the list, you get an option for
Contains.

Martin

http://homepage.ntlworld.com/martin.rice1/

--
mrice
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532738

--

Dave Peterson

Conditional Format Formula "includes"
 

In conditional formatting this will suffice...

=SEARCH("closed",A1)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=532738