| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change the color of one word throughout a worksheet
You can also do it if the cell CONTAINS yes (but the whole cell would get the
formatting, not just the word). Select ALL cells; Conditional Formatting: Formula is: =NOT(ISERROR(FIND("yes",A1))) Bob Umlas Excel MVP "wfbarron" wrote: I gave a worksheet that has yes and no answers, how can I change the color of the word yes throughout the worksheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| worksheet cell color change | New Users to Excel | |||
| Allow users to change the color of the comment indicator color so. | Excel Discussion (Misc queries) | |||
| Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
| Auto color change to tabs in worksheet | Excel Worksheet Functions | |||
Threaded Mode
