If you change one and fail to change the other, then you won't get the desired results. Of course, the only caveat to this solution is that you will need to keep the conditions in the macro and the conditions in the conditional formats in sync with each other. This should yield the same count of cells, but is much easier to handle programmatically. The result is that you count cells matching conditions rather than count cells that are colored red as a result of those conditions. Given the difficulty of the task, it may just be easier to recreate the conditions within the macro, and then see which cells meet these conditions. The following page on Chip Pearson's site demonstrates the difficulty in determining conditional colors: There are ways you can work around this with a macro, but it is not for the faint-of-heart. You cannot directly check in a macro what the color of a cell is based on a conditional format. Ronald wants to know if there is a way to count these conditionally red cells, as well. He knows how to create a macro that will examine the cell color and do a count if a cell is formatted directly as red, but the macro won't work with cells that are conditionally formatted. He wants to count the number of cells that are red in the worksheet. The conditions result in the cells being different colors. Ronald has a worksheet that utilizes conditional formatting.
0 Comments
Leave a Reply. |