Hello,

I have been managing contracts and their end dates, I have done this by conditional formatting. For example, if a contract is due to end within 6 months it will highlight red, if due to end within 12 months amber and within 24 months green.

I will be continuously updating this sheet with new contracts and would love to be able to automatically count the number of contracts that are highlighted red (due within 6 months), amber (12 months) and 24 (months) so I can quickly summarize that there are x amount of contracts due to end within 6 months. I know how to use the count functions but coupling this with the conditional formatting has thrown me.

Any help would be greatly appreciated,
Alex