Forum Discussion

North_Yorks's avatar
North_Yorks
Copper Contributor
Sep 23, 2020

COUNTIF function but with conditional formatted cells

Hi,

 

I have a spreadsheet that uses conditional formatting via a drop down list that the cell changes colour depending on result. I want to be able to count the number of cells that are certain colours. I have watch tutorials for Get.cell but that can't work with condition formatting. I've also looked at setting up VBA but can't seem to get that to work either wasn't sure if this is because of the formatting.

Please help is there a solution to this?

Thanks, Jenny

Formulas and Functions
Macros and VBA

3 Replies

    • North_Yorks's avatar
      North_Yorks
      Copper Contributor
      Sep 23, 2020
      Hi i have found a function COUNTIFS that seems to work. Thanks
    • North_Yorks's avatar
      North_Yorks
      Copper Contributor
      Sep 23, 2020

      HansVogelaar 

      There isn't actually any values in the cell just a colour - or would it count the list value? Ive hidden the text by making it same colour as cell so only a colour shows.

Resources