Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to find cell values containing X
I would like to use conditional formatting to highlight cells containing a
particular word. Is there a formula I can use in the Conditional Formatting dialog box? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to find cell values containing X
Hi Melissa
1. Select the cell/Range 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula (For whole content of the cell) =H1="x" ('x' within the cell content ) =ISERROR(SEARCH("x",I1))=FALSE 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "Melissa" wrote: I would like to use conditional formatting to highlight cells containing a particular word. Is there a formula I can use in the Conditional Formatting dialog box? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to find cell values containing X
('x' within the cell content )
=ISERROR(SEARCH("x",I1))=FALSE You can reduce that to: =SEARCH("x",I1) It'll evaluate to either the error #VALUE! or a number from 1 to LEN(I1). When it evals as an error the format won't be applied. When it evals as *any number other than 0* the format will be applied. In logical tests Excel evaluates 0 as FALSE and *any number other than 0* as TRUE. -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Hi Melissa 1. Select the cell/Range 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula (For whole content of the cell) =H1="x" ('x' within the cell content ) =ISERROR(SEARCH("x",I1))=FALSE 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "Melissa" wrote: I would like to use conditional formatting to highlight cells containing a particular word. Is there a formula I can use in the Conditional Formatting dialog box? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula help...find values and grouping together... | Excel Discussion (Misc queries) | |||
Find One Of Several Values Within A Cell | Excel Worksheet Functions | |||
Formula to find greater of two values??? | Excel Discussion (Misc queries) | |||
Can you Find and Replace values with in a formula? | Excel Discussion (Misc queries) | |||
Need formula to find and sum values in a different spreadsheet | Excel Worksheet Functions |