| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Word Associated Shading or Color
I am trying to find out if it is possible to take an excel spreadsheet and shade or color a certain box based on the text that I have in that box. For instance, if I have the word CREATE in 75 different places on a specific spreadsheet, is there a function that will allow me to shade that specific word green throughout the entire sheet. -- howiedog ------------------------------------------------------------------------ howiedog's Profile: http://www.excelforum.com/member.php...o&userid=27213 View this thread: http://www.excelforum.com/showthread...hreadid=467258 |
|
#2
|
|||
|
|||
|
It's called conditional formatting. Format--Conditional Format.
************ Anne Troy www.OfficeArticles.com "howiedog" wrote in message ... I am trying to find out if it is possible to take an excel spreadsheet and shade or color a certain box based on the text that I have in that box. For instance, if I have the word CREATE in 75 different places on a specific spreadsheet, is there a function that will allow me to shade that specific word green throughout the entire sheet. -- howiedog ------------------------------------------------------------------------ howiedog's Profile: http://www.excelforum.com/member.php...o&userid=27213 View this thread: http://www.excelforum.com/showthread...hreadid=467258 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Object copied to Word not printing in color | Excel Discussion (Misc queries) | |||
| Excel formulas based upon the color shading of a cell? | Excel Worksheet Functions | |||
| Can the results of a formula drive color shading? How? Can it be . | Excel Worksheet Functions | |||
| cell color shading | Excel Discussion (Misc queries) | |||
| Is there a way to change the default shading color ? | Excel Discussion (Misc queries) | |||
Linear Mode
