Write a formula based on the logic of *WHY* the numbers are highlighted
green. If they're highlighted using conditional formatting then you should
be able to write a formula based on the conditional formatting logic.
Find all colored cells and sum all:
Here is a quick way without VBA or formulas.
Edit > Find > clear "Find What" > Options > Format >
"Choose Format From Cell" > select sample cell >
Find All > scroll to end of list, press CTRL+SHIFT
and click on the last entry of the list.
Right click Status Bar and check Sum.
HTH,
Ryan---
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.