Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditonal Format
Dear all,
A column contains cells fuill of text. Using conditonal formatting I wish to highlight those cells that somewhere in their text contain a certain word or phrase, e.g. "External". Any ideas? Thanking-you Neil |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditonal Format
Hi,
To conditionally format your cell(s): In 2003: 1. Select the cells you want to format, say A1:A10 2. Choose Format, Conditional Formatting 3. Choose Formula is from the first drop down 4. In the second box enter the formula: =FIND("External",A1) 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK twice. In 2007: 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =FIND("External",A1) 5. Click the Format button and choose a format. 6. Click OK twice Find is case sensitive, if you don't want that use SEARCH -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Neil Pearce" wrote: Dear all, A column contains cells fuill of text. Using conditonal formatting I wish to highlight those cells that somewhere in their text contain a certain word or phrase, e.g. "External". Any ideas? Thanking-you Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditonal Format | Excel Discussion (Misc queries) | |||
Matching specifc dates using Conditonal format | Excel Worksheet Functions | |||
Conditonal Format Problem | Excel Discussion (Misc queries) | |||
Conditonal Format Formula | Excel Worksheet Functions | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) |