total using colour?

[jackdiamond]

Hi,

Is there anyway to get a total but only using colours?

eg, I want to colour blocks in blue and at the end of the row, I want it to count how many were blue.

Can this be done?

Thanks
Stu

 

[jeffreybrown]

Once the macro is pasted into a standard module in the workbook your working with, then you just use the formula to call the function. Just like Excel has built in formula's, this function is a user defined function.

http://www.cpearson.com/excel/writingfunctionsinvba.aspx

 

[jackdiamond]

perfect!! I have finally sorted it out in my own head.

Just one more question,

When I change the colours of cells, there is a delay before the total is updated

eg, I change one cell to red but nothing happens, so I change another cell and the first cell total is now there.

It's like it is always one move behind. Is there a refresh button or something?

Once again, thank you so much for your help!!

 

[jeffreybrown]

Try F9

 

[jackdiamond]

brilliant, thank you so much for all your help

 

[jeffreybrown]

Glad it worked out Stu