| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
| conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
| Conditional format formula | Excel Discussion (Misc queries) | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Conditional Format Formula Needed | Excel Worksheet Functions | |||
Linear Mode
