Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count cells colored by conditional format

Status
Not open for further replies.

wmbb

Technical User
Jul 17, 2005
320
NL
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 ?
 
The top of the column is a date.
If the date is Saturday or Sunday the whole column is red.
I would like to count the red cells in a user selected range.

Now I'm working on a workaround and put the red cells locked.
Then I can count the locked cells in the range.
It works for this purpose but I was wondering if I could do it without the workaround.
 
What mint was implying was, use the same criteria used in the CF in your count function.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
The workaround worked for me.
I couldn't use the same criteria because the top of the column is not necessary in the user selection.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top