Count Nofill conditionally formatted cells.

[kmmsquared]

I have created a live calendar without using VBA. The dates in the calendar are conditional formated for weekends, every other Friday (depending on the first Friday I select) and Holidays. These cells are all set to be different colors. I would like to be able to count the conditionally formatted cells without a fill. I don't care about the colors or where they are in a specific 7 day period because they will change. On a 7 day basis I want to count only the conditionally formatted cells that have no color.

 

[ZVI]

An easy way is in setting formulas of conditional formatting (CF) in auxiliary (hidden) cells.
In this case CF formula is just the reference to the aux cell, and you can use values of aux cells in other formulas

 

[kmmsquared]

I'm not sure if that will work, as I already have the conditional formatting applied to the whole calendar. It isn't so bad for the holidays to do it that way, but for the conditional formatting that applies to every other row depending on the date I fill in, it is difficult.

 

[crook_101]

Hi,

Without seeing your CF formula, sheet layout it is difficult to give an exact response.....I assume it will be something along the lines of:

=countif("7 day range","same formula as your CF")

Sorry to be so vague but if you could post some of your data/formula, i could give a more exact response

Cheers,
Ian