Can someone help me please? I am trying to get my spreadsheet to count cells based on their colour after they have been conditionally formatted. I have read various threads on here and made some progress thanks to @Jamil Mohammad I have put a VDA in as per advice elsewhere. However, it is clear that I am making mistakes somewhere. I have attached my file. The formula is put in next to the red cell on the analysis tab. Any help greatly appreciated.