Forum Discussion
How to summarise coloured cells which are determined by conditional formatting?
I have an excel document which tracks how close a product is to it's expiry date by means of a red amber and green system. Conditional formatting is applied based on where todays date is relative to ...
To keep it simple I'd add a series of helper columns / formula that mimic the conditional formatting rules returning 1s and 0s then refer to those cells to do your summary calculations