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.