I was wondering if it is possible to create a heat map on excel, where values of 0 are excluded from the ranking, and the cells which contain the same values are highlighted in a heat map fashion?
In this case I have cells with 0 which I don't need. But I'd like cells with the same value (e.g. 0,04%) to be highlighted in green, and values of say, 0,05% in yellow and so on.
