VBA Macro to format individual characters in a cell given certain conditions

[DavidBW]

Hello

I have been asked to modify certain cells in a report so that individual characters change colour depending on certain conditions.
Each cell represents a group of actions, each action has a number and at the time of producing the report will be in a certain state of readiness red, amber, green or unclassified. I would like the individual characters to be formatted in the colour that reflects this state of readiness.

An example spreadhseet is attached. The colours of the characters in the desired output column in the "Output" tab are dependent on the status colours in the "Core" tab.

Would be greatly appreciated if someone could get their brains round this one and come up with a workable solution!

[DavidBW]

nudge? Any clues would be great ;-)

[snb]

Did you ever dive into conditional formatting ?

[DavidBW]

Not sure how I can apply this to specific characters within the cell.