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,