I am working with Excel 2003. I have protected the sheet and have chosen not
to allow formatting while protected because this allows them to change just
to much. However I would like for them to be able to change the font color. I
cannot figure out a way to allow them to change ONLY the font color. Please
HELP is there a way around this??

You could use conditional formatting by introducing a new column and by using
formula to determine which cell to format.

There will be a limit to three colors. Lets say R=Red, B for blue and G for
green.
Set the area which is to include the formatting. I'm saying that if B1 has
an R in it then text in A1 is red.
=B1="R"
Obviously you will need to carry that on for the other two colors.

It's a long time since I used 2003 so I've kept this as simple as possible.
I think it should work but I'm not sure about text color. It will allow fill
definitely.

Try it.

Finally, please don't post questions with UPPER CASE and !!!!!. It puts
people off. I ignored it for a while.

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"quest_hell" wrote:

I am working with Excel 2003. I have protected the sheet and have chosen not
to allow formatting while protected because this allows them to change just
to much. However I would like for them to be able to change the font color. I
cannot figure out a way to allow them to change ONLY the font color. Please
HELP is there a way around this??