I have a rule (conditional format) applying a format to certain cells (fill color is red, color code = 255).
All other cells are white (interior.color = 16777215).
I want to count the red cells but the interior.color code of the formatted cells is also 16777215 instead of 255 !!!
How can I count the cells formatted with the conditional format since the color code seems to stay the same as the not formatted cells ?
All other cells are white (interior.color = 16777215).
I want to count the red cells but the interior.color code of the formatted cells is also 16777215 instead of 255 !!!
How can I count the cells formatted with the conditional format since the color code seems to stay the same as the not formatted cells ?