choice to colour text

[Nick]

Hi, hope someone can help.

I have a shared spreadsheet with quite a lot of users.
I need to categorise who is using the spreadsheet so that
text that they add comes up in a different colour. Is
there anyway to do this?
I realise they could just change the text colour
themselves, but it would be simpler in the long run if
when they tried to input text they were faced with a
question, and the answer changed the text colour
automatically.

Any help is much appreciated!

Nick

 

[Mark]

Hi,
Maybe a user has to log in to the worksheet. eg when the
sheet opens, an input box asks for username. The answer
is checked against a predefined database of users and
colors. The fontcolor is then set for that user.

Regards
Mark