Adding numbers in cells based on colour

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been tasked with designing a spreadsheet which will add figures within
a given column based on the "text" colour. Having gone through the help
functions i can see that this does not appear to be possible. However, could
this be achieved through VB code within a cell or something similar?
 
You must log in or register to reply here.

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

cell vlue based on cell back colour 6
colour cells, same numbers different worksheets 1
Conditional formatting based on adjacent cell? 1
Cell Colours 8
Function for summing or counting cells based on a specified fill color 2
Can you transfer cell colour with value 3
how do i change cell text colour based on value in other cell 2
Excel 2007 conditional formatting & cell colour. 2

Back
Top