98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel course london - Adding formated cells
advanced excel course london - Adding formated cells
Resolved · Low Priority · Version Standard
Rebecca has attended:
Excel Advanced course
Adding formated cells
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
RE: Adding formated cells
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |