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