Jacob,

Thanks for the response!

This works if I'm only formatting a single cell (i.e. Formula is
=FIND("-NE-",A2) will format cell A2.)

However, I can't get it to work for an entire column. Even if I select the
column and change the formula to =FIND("-NE-",A:A) it is ineffectual. I
adjusted the formula several ways with no success.

Any ideas for getting the same concept to work on a column of data?


"Jacob Skaria" wrote:

1. Select the range

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=FIND("-NE-",D1)
Click Format ButtonPattern and select your color (say Red)

4. Click on Add button.

5. For Condition2Select 'Formula Is' and enter the below formula
=FIND("-SE-",D1)
Click Format ButtonPattern and select your color (say Orange)

6. Hit OK

--
If this post helps click Yes
---------------
Jacob Skaria


"Amy" wrote:

I would like to be able to conditionally format data that is contained within
a cell even if there is other data in the cell.

For example:

A2 - East-NE-NO-ETC
A3 - East-NE-TP-Critical
A4 - East-SE-NO-Investment
A5 - East-SE-CM-Investment

Id like to be able to conditionally format all of the cells in Column A
that contain €œNE€� to be one color, and all that contain €œSE€� to be another
color.

Is that possible? How? Thanks in advance for any input!