Derek McGill
Active Member
Any tips as to the best way to update cells with color function result after vba changes cell color ?
Color change in cells
- Thread starter Derek McGill
- Start date
Derek
If the VBA is changing a cell's color or font color, you can simply change it, when the VBA has finished
You could also apply a Conditional Format to override the settings
I'd suggest changing the VBA to do what you want correctly in the first place, or remove the color sections of the VBA and use other techniques to apply the color
As always a sample file will allow a more targeted response
If the VBA is changing a cell's color or font color, you can simply change it, when the VBA has finished
You could also apply a Conditional Format to override the settings
I'd suggest changing the VBA to do what you want correctly in the first place, or remove the color sections of the VBA and use other techniques to apply the color
As always a sample file will allow a more targeted response
Derek McGill
Active Member
Hui
Is there any way to get total no. of cells in a range that have a red/green fill color?
Is there any way to get total no. of cells in a range that have a red/green fill color?
This is a commonly asked question here at Chandoo.org
Using Help in the Upper Right of this and every page would have found several answers
Here is but one:
http://forum.chandoo.org/threads/how-to-count-sum-cell-based-color.8050/
Using Help in the Upper Right of this and every page would have found several answers
Here is but one:
http://forum.chandoo.org/threads/how-to-count-sum-cell-based-color.8050/
Derek McGill
Active Member
Hui
The only catch is, if you make any changes in the data range, formula will not automatically recalculate the result.
The only catch is, if you make any changes in the data range, formula will not automatically recalculate the result.
NARAYANK991
Excel Ninja
Hi ,
See if this helps :
https://sites.google.com/site/e90e50fx/home/sum-by-color-calculate-when-color-changed
Narayan
See if this helps :
https://sites.google.com/site/e90e50fx/home/sum-by-color-calculate-when-color-changed
Narayan
Derek McGill
Active Member
Hui
That's what I meant to say.
Narayan
That code is not for counting no. of cells with the same color in them.
That's what I meant to say.
Narayan
That code is not for counting no. of cells with the same color in them.
NARAYANK991
Excel Ninja
Hi ,
The web page I posted a link to , is describing a technique , using which any change in cell color will trigger a worksheet recalculation ; this can be used in any situation , and is not related to whether you are summing or performing any other operation.
Narayan
The web page I posted a link to , is describing a technique , using which any change in cell color will trigger a worksheet recalculation ; this can be used in any situation , and is not related to whether you are summing or performing any other operation.
Narayan