Count Coloured cells

[baileyb103]

Hi. I have a spreadsheet for some assessment results (See my other posts). the cells are condition formatted so that they turn red when the assessment has failed. I am trying to get a formula to count the cells that have turned red, for each individual trainee, however the normal count functions don't seem to work with conditional formatted colours. Is there anything else I could do other than just manually in-puting the figures? The document is uploaded to a Sharepoint so would a VBA work if someone else opened the document via the Sharepoint (my knowledge on VBA is practically nothing).

Many thanks in advance.

 

[baileyb103]

From the looks of your screen shot, your %'s aren't formatted as %'s - try this subtle change instead.

=COUNTIFS(B3:AO3, "Fail") + COUNTIFS(B3:AO3, ">0",B3:AO3,"<65")

That works now, thank you.