Multiple fonts in a single cell

[RachelMads02]

Hi guys, My name is Rachel. I was recently working on a workbook in another thread titled: Indexing formula needed for two pages at:

http://www.excelforum.com/excel-form...two-pages.html

I have a workbook attached below that has two sheets "Options" and "Cases". On the "Cases" sheet i have a column titled "Quality level" - column D. When i place the letters E,P,R,M, in any cell in column D they will place the corresponding item in Row 3 of the "options" sheet depending on the option choice. For example if i place the letter E in Quality Level cell D3 it will display in Options cell B3:D3.

If i place any combination of letters in any cell in Quality Column D they will reflect in the corresponding cells in Row 3 of the Options Sheet. I hope that's not too confusing.

Now what I'm looking to do and i don't even know if it's possible, is that I want the letters

E = Purple Font
P = Blue Font
R = Green Font
M = Orange Font

So that any time i place the letter E in any cell in column D it will always display as purple. The same for P,R, and M. Is that possible?

Thanks in advance to anyone who takes the time to help!!