| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - letters present
On Mon, 2 Nov 2009 06:43:01 -0800, Jacob Skaria
wrote: --If you are using XL2007 goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format.. Exactly --for exact match enter this formula in the box below: =EXACT(LEFT(A1,2),"PC") Cool! Thanks. --Click the Format button. Select the desired style(s) and click OK Or select the "Custom Style", and change nothing color or font wise, and select "Bold" checkbox to arrive at the resuestor's query solution. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting string in groups of letters... | Excel Worksheet Functions | |||
| Formatting cells for letters and numbers | Excel Worksheet Functions | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
| Formatting Upper Case letters | Excel Worksheet Functions | |||
Threaded Mode
