Count Nofill conditionally formatted cells.

kmmsquared

New Member
Joined
Jan 7, 2011
Messages
33
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.
 
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
 
Last edited:
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top