You can use Conditional Formatting to set colours depending on some
criteria, but it will apply to a whole cell - you cannot get it to
apply to only part of a cell.

Hope this helps.

Pete

On Oct 2, 12:09 pm, barry24uk
wrote:
Just wandering if it's possible to alter the text colour using a formula
command instead of using the Text and Fill colour buttons on the Toolbar?
For example - I would like the first halve of the text in a cell to be Blue
and Bold and the last half of the text to be Gray and standard.