Forum Discussion

Vladimir_Trotsenko's avatar
Vladimir_Trotsenko
Copper Contributor
Jun 29, 2022

How to count the number of completed conditional formats

Hi to all.

There is a table with values and applying conditional formatting as in the example below. The task is to count how many of these same arrows. Each line has its own formatting rule. I can write a macro, but i need to know how to understand which arrow it.

 

excel
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Jun 29, 2022
    @Vladimir
    I would make a helper column for counting arrows using the same rules. But only if every line really has its own rule. Your data doesn't actually look like it. Here you can probably work with LOOKUP(). Can you explain your rules in more detail? Possibly upload a sample document.
    • Vladimir_Trotsenko's avatar
      Vladimir_Trotsenko
      Copper Contributor
      Jun 30, 2022

      dscheikey 

      On link you can download the part of the working Excel file. There one from more sheets with all information and working formatting rules.

      • dscheikey's avatar
        dscheikey
        Bronze Contributor
        Jun 30, 2022

        Vladimir_Trotsenko Sorry, I won't be able to help here. I use Excel for the web and I can't see and change the conditions for the symbols. I can't create custom formatting either. So I'm not getting anywhere here. Someone else would have to look at it and help.

Resources