Change default text color without reformatting the sheet.
I have a premade worksheet that I want to send to others so they may add and
edit information. I need the text they type to appear in a pre-determined
color that I choose while the existing unchanged cell data remains black.
When they save it and send it back to me, I need to see the data they added
or edited in the new color. I don't need to protect the sheet (unless your
answer requires it).
Thank you in advance for your help!
|