Hi,
I have currently formulated the following formula,
=IF([% Committed to Date]1 - [Project Status %]1 < 0.25, "Green", IF(AND([% Committed to Date]1 - [Project Status %]1 >= 0.25, [% Committed to Date]1 - [Project Status %]1 <= 0.75), "Amber", "Red"))
which is working efficiently, but problem occurs it shows me the Wording not the Colours or symbols
Many Thanks