G
guy325
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
within a range of cells, that they appear in a given color
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
Not enough information to make much of a guess, but see help on Conditional
Formatting.
Gord Dibben MS Excel MVP
Formatting.
Gord Dibben MS Excel MVP
G
guy325
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.
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.
D
Dave Peterson
Watch Debra Dalgleish's video:
http://contextures.com/xlVideos06.html#CondFormatOtherSheet
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.
http://contextures.com/xlVideos06.html#CondFormatOtherSheet
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.
G
guy325
Thanks Dave!
Dave Peterson said:Watch Debra Dalgleish's video:
http://contextures.com/xlVideos06.html#CondFormatOtherSheet
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.