Problem with Conditional Formatting

Hey,

I have a workbook with a range of C3:E17 and i want excel to format a cell colour if specific text within a string is entered into a cell. The cells contence will be similar to this for example. John Smith Application or John Smith Settlement. How do i make excel format one colour for Applications and another for Settlements?

Hi!

Condition 1
Formula is: =isnumber(search("settlement",a1))
Set the desired style(s)

Condition 2
Formula is: =isnumber(search("application",a1))
Set the desired style(s)

OK out.

Change the cell references to suit.

Biff

"thetoppy" <[email protected]> wrote in
message news:[email protected]...
>
> Hey,
>
> I have a workbook with a range of C3:E17 and i want excel to format a
> cell colour if specific text within a string is entered into a cell.
> The cells contence will be similar to this for example. *John Smith
> Application* or *John Smith Settlement*. How do i make excel format one
> colour for Applications and another for Settlements?
>
>
> --
> thetoppy
> ------------------------------------------------------------------------
> thetoppy's Profile:
> http://www.excelforum.com/member.php...o&userid=33436
> View this thread: http://www.excelforum.com/showthread...hreadid=535407
>