I want to set up a cell in Excel with solid fill depending on % completion of other tasks. The data bar conditional format will do it, but I want the whole cell to fill once the task is complete.
It is normally designed for comparison, so it has a 0 point at the centre with + and - either side. Of course I want it to fill from the left and completely fill when it reaches 100%. I have tried asking it to fill from the left, but it still goes half way. All options in the "negative axis" dialog box don't change it - does anyone know what I can do?