Change a cell color based on percentage

  • Hi,
    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.

    Manny Ramirez

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!