Recalulate on Format change...

J

J S

I've written a function that calculates the sum of all the cells in a
worksheet that have red colored text.

When I use this formula in a cell it does not automatically recalulate it
self when ever the user changes the TEXTCOLOR of a cell to be the color red.

I already added the application.volatile statement but appartently the
function will still only recalulate when a value is changed and not when a
color/format is changed!

Is there anyway to get a function to automatically recalculate when a color
on the sheet is changed? Is there any onFormat Change events?

-J
 

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

Conditional formatting 2
Change row colors based on a cell value 1
stop automatic recalulation when error occurs 1
Automatically change the text format the cell when use a specific text 10
Changing the color of rows - conditional formatting 3
Changing cell color with a formula? 4
Formatted Result from an IF function 3
Problem with MS Word paragraph and character styles: format getting messed up 2

Top