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 spreadsheet 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!