Forum Discussion
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 ...
@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.
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.
On https://docs.google.com/spreadsheets/d/1LYTwkR2CiB7wDjMcyPldjJtRuQkEe0KR/edit?usp=drivesdk&ouid=113729708676222517319&rtpof=true&sd=true you can download the part of the working Excel file. There one from more sheets with all information and working formatting rules.
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.
