multicolor text string

[Treeskier]

Hello,

How can I change the color of text in a text string?
Example: 140/46/5 where '46' is colored red.

Thank You

 

[Dave Hawley]

Hi

Select the cell. Then higlight the text "46" in the formula bar. Now
either right click and Format cells, or select the wanted Font color
from the Formatting toolbar

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Treeskier]

Thank You very much.