I have used Conditional Formating to identify which cells contain figures that have reached targets and figures that have not in a Red, Amber and Green format.

I would like to automatically add these formated values to identify how many cells contain red, green and amber.

Many thanks

Hi Rebecca, many apologies in the delayed reponse!

There is a function in Excel called the Conditional Sum Function, this is an "Add in" and can be found under the Tools menu. It is not loaded in excel by default.

Once it is loaded there are four steps,

1) Identify the range of cells you wish to use
2) Put in the conditions you wish the numbers to be differentiated by, similar to your conditons you have used in your Conditional Formatting.
3) Choose the way you want your results to be displayed
4) Choose a cell or a number of cells you wish your results to be put.

Take a look at that option

Good luck