Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |