Conditional formatting colour fill

Registration date
Friday January 29, 2016
Last seen
January 29, 2016
- Jan 29, 2016 at 07:48 AM
Hi all,

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?