| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
setting up conditional text input
I wish to creat a senario that when certain names from a list are typed
within a range of cells, that they appear in a given color |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting up conditional text input
Not enough information to make much of a guess, but see help on Conditional
Formatting. Gord Dibben MS Excel MVP On Wed, 2 Dec 2009 15:44:01 -0800, guy325 wrote: I wish to creat a senario that when certain names from a list are typed within a range of cells, that they appear in a given color |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting up conditional text input
Sorry, I'm a rookie. I have a roster of hockey players. 22 regulars and
many subs when regs are unavailable. When I type in subs names I would like them to automatically be in red while the regulars remain in black. "Gord Dibben" wrote: Not enough information to make much of a guess, but see help on Conditional Formatting. Gord Dibben MS Excel MVP On Wed, 2 Dec 2009 15:44:01 -0800, guy325 wrote: I wish to creat a senario that when certain names from a list are typed within a range of cells, that they appear in a given color . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting up conditional text input
Watch Debra Dalgleish's video:
http://contextures.com/xlVideos06.ht...rmatOtherSheet You'll make a list of regulars (or substitutes) and put that in column A of that second sheet. Then use the technique that Debra shares. guy325 wrote: Sorry, I'm a rookie. I have a roster of hockey players. 22 regulars and many subs when regs are unavailable. When I type in subs names I would like them to automatically be in red while the regulars remain in black. "Gord Dibben" wrote: Not enough information to make much of a guess, but see help on Conditional Formatting. Gord Dibben MS Excel MVP On Wed, 2 Dec 2009 15:44:01 -0800, guy325 wrote: I wish to creat a senario that when certain names from a list are typed within a range of cells, that they appear in a given color . -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting up conditional text input
Thanks Dave!
"Dave Peterson" wrote: Watch Debra Dalgleish's video: http://contextures.com/xlVideos06.ht...rmatOtherSheet You'll make a list of regulars (or substitutes) and put that in column A of that second sheet. Then use the technique that Debra shares. guy325 wrote: Sorry, I'm a rookie. I have a roster of hockey players. 22 regulars and many subs when regs are unavailable. When I type in subs names I would like them to automatically be in red while the regulars remain in black. "Gord Dibben" wrote: Not enough information to make much of a guess, but see help on Conditional Formatting. Gord Dibben MS Excel MVP On Wed, 2 Dec 2009 15:44:01 -0800, guy325 wrote: I wish to creat a senario that when certain names from a list are typed within a range of cells, that they appear in a given color . -- Dave Peterson . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text format - setting text colour with code | Excel Discussion (Misc queries) | |||
| Conditional Format Pending Text Input | Excel Discussion (Misc queries) | |||
| Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
| Setting Conditional Formatting | Excel Worksheet Functions | |||
| Setting up a form to input into selected worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
