Problem with Conditional Formatting

T

thetoppy

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?
 
B

Biff

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
 
Top