Forum Discussion
filtering heatmap by a color
Hi, I have a problem with my heatmap. I would like to add ann option to a dashboard that would show me for example just clients with 4 or more red/green fields. I work on excel 2010.
Example of how my heatmap look is attached.
Hi Bartosz,
You have some conditions for your red/green rules. Add one more heleper column to your range and COUNTIF in it from B to I where such condition(s) match. After that filter the range based on that column.
