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?


--
thetoppy
------------------------------------------------------------------------
thetoppy's Profile: http://www.excelforum.com/member.php...o&userid=33436
View this thread: http://www.excelforum.com/showthread...hreadid=535407

Problem with Conditional Formatting
 

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" wrote in
message ...

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