How set totals of various cells with per colour fill value?

  • Thread starter Thread starter AA Arens
  • Start date Start date
A

AA Arens

I have a sheet containing values as follows.


April May June
company 1 43
company 2 5
company 3 17


The cell values are also coured to indice a status.
Somewhere beside the table I want to mention the totals of the cells,
per status (so per colour).
How to perform the latter?



Thank you.

Bart
Excell 2003
 
Bob, where to set the script in VB, I cannot find the macro editor in
Version 12 of Excel.

Bart
 
Bob, where to set the script in VB, I cannot find the macro editor in
Version 12 of Excel.

Bart
 
Goto the VBIDE (Alt-F11), add a new code module (Insert>Module)< and add it
there.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 

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.

Ask a Question

Similar Threads

Looking for the value that indicates last row number that has filled cells 3
How to set cell value to emptry if three other columns are empty too 1
how to totalize only column value from certain accounting -> Currencyformat 10
Value of sheet A cell = sheet B cell => fill in sheet name 4
change certain cell colours in VBA 2
Can you transfer cell colour with value 3
How to equal a cell in another worksheet incl fill colour 3
Changing cell colours based on a cell value 1

Back
Top