This is brilliant, it all works, thank you so much! I added another column to count the number of blank cells to calculate the middle/amber cells ...
I don't know if this helps but I have also attached an example of a row for one student. I am determining the colour counters in the first 3 cells...
That's amazing thank you, here are the criteria:
Many thanks for your reply, apologies for not getting back to you sooner, it has been a very busy week. I have just tried to work out how to do thi...
The cells that are being counted are coloured using Conditional Formatting. I have removed this and applied the colouring manually, and the function ...
I was able to remove DisplayFormat from the function. The updated code gives the same, correct Formula Result as before in the Function Arguments wind...
Many thanks for looking into my issue, my code is as follows: Function GETCOLORCOUNT(CountRange As Range, CountColor As Range) As Single Dim Cou...