Progress bar (%) hopefully simple and quick

I am trying to create a progress bar which i am manually creating by simple formatting the following range of cells with a border - so basically displaying a rectangle with no fill

d5:m5

i have tick boxes on my spreadsheet - i have already set up the calculations in another cell so that when 7 out of 10 boxes are ticked - y2 will display 70% etc. that's all done.

What i need now is to somehow tell my 10 cells to change colour according to the number in Y2.

e.g. if Y2 says 70% i would like the first 7 cells of d5:m5 to change green - creating the illusion of a percentage bar filling up.

is there an easy way to conditional format this or script this?

or is their another easier way to do this///.



thanks,

I use this to put a message on the status bar.
You could probably adapt it to fill the cells.

Please Login or Register  to view this content.

Hi there Muzza86,

Try the following, although am sure there are cleaner ways to do it. You could run it on a change event to have it work automatically or incorporate it into existing code.

Please Login or Register  to view this content.

Mowgli