I have a range of cells 6 columns 9 rows
which are either coloured red or green depending on the status of a task green completed red uncomplete. I want to be able to use a function/formula/macro to calculate the percentage of cells which are green.
Cheers Dusty
which are either coloured red or green depending on the status of a task green completed red uncomplete. I want to be able to use a function/formula/macro to calculate the percentage of cells which are green.
Cheers Dusty