two font colors in one cell

[borntobe]

Hi,
My workbook and worksheets are protected by password.
I want to use two colors in a cell, red and green.
Can I unprotect the sheet1 while the cell is used by user, then after finishing entering text, can I protect again?
This way I think users can use two font colors.

Can I do this in macro?
Thanks in advance.

 

[bstory84]

The Short answer is no, you cannot have 2 colors in a single cell as the cell color. It is possible to create a conditional format that changes the cells color based on a user defined condition. You can however have a cell color and a text color.
In regards to unprotecting the worksheet question... This seems to defeat the purpose of worksheet protection. You could modify the protection properties to allow users to format cells.