I have created a scorecard which shows a cell range c10:z13, there is cells with Green, Amber, Red and Yellow to represent the status based on a percentage.
100% - Complete (GREEN)
5-95% - In Progress (AMBER)
0% - Not Started (RED)
X - Did Not complete (YELLOW)
I have tried to use conditional formatting, the colour is change for the cell that contains 100% rather the cell with the color i.e Green. Theoretically I should be able to change it to a percentage from 50% and I would like the cell with the color GREEN to change AMBER etc.
Does anyone have an example on xls that I can see this type of example working. Is Conditional formatting the best way to handle this type of scenario.