Percentage of completed tasks based from cell colour

[markofawaz]

Hi there,

I'm new here so hello everyone!

I've been tasked with organising some files, i've been asked to look at an excel sheet that has lots of different jobs on it. Once a job is completed, the background colour is manually changed to a green. Now i want to make a front sheet with a percentage of the completed tasks and uncompleted tasks based on what colour the cell is, is there a way of me doing this?

Thanks!

Mark