Conditional Formatting
 

Hey,

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

--
thetopp
-----------------------------------------------------------------------
thetoppy's Profile: http://www.excelforum.com/member.php...fo&userid=3343
View this thread: http://www.excelforum.com/showthread.php?threadid=53539

Conditional Formatting
 

Try:

1. Select the range C3:E17 with C3 the active cell
2. Select Format Conditional Formatting
3. Select "Formula Is" from the dropdown
4. Enter the following in the formula window:
=Find("Settlement", C3)
5. Click the Format button and select the desired format
6. Click OK to close the Format Cells dialog
7. Now click the Add button to add a new conditional format
8. Repeat steps 3 to 6 except enter this formula:
= Find("Application", C3)
9. After closing the Format Cells dialog click the OK button in the
Conditional Formatting dialog to finish

Note that the above formulas are relative and will be set to each cell
within the selected range, not just cell C3.

Regards,
Greg

"thetoppy" wrote:


Hey,

I have a workbook with a range of C3:E17 and i want excel to format a
cell 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=535398

Conditional Formatting
 

Use Search instead of Find if you don't want it to be case-sensitive.

Greg

"thetoppy" wrote:


Hey,

I have a workbook with a range of C3:E17 and i want excel to format a
cell 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=535398