H
Hook
I have a number of different groups with multiple individuals in each. Each
group and the members within it are indentified by the text color of the id
number . For example: If an individual is in Group A, his identification
number might be in red text, Group B's folks might be green, etc. My
question is this:
Is there any way to change the text color of the id number, on the fly, to
the correct group color. In other words: I would like to be able to type in
Mr X's id # and have the system know, by looking at some sort of formatting
statement or whatever, that Mr X should be blue and change the text color
accordingly. Have tried conditional formatting. However, it only allows
three condtions and I have more groups than that to be identified, I couldn't
make it work. Could be my lack of sophistication too, I'm sure. Thanks for
any help. (version 11.1 2004 Mac)
group and the members within it are indentified by the text color of the id
number . For example: If an individual is in Group A, his identification
number might be in red text, Group B's folks might be green, etc. My
question is this:
Is there any way to change the text color of the id number, on the fly, to
the correct group color. In other words: I would like to be able to type in
Mr X's id # and have the system know, by looking at some sort of formatting
statement or whatever, that Mr X should be blue and change the text color
accordingly. Have tried conditional formatting. However, it only allows
three condtions and I have more groups than that to be identified, I couldn't
make it work. Could be my lack of sophistication too, I'm sure. Thanks for
any help. (version 11.1 2004 Mac)