count total cells if they are a certain color-reverse conditional

G

Grams

I have a yearly work calendar that is shaded (color coded) to match work
days, holidays, non paid days, etc. Is there a conditional formatting that I
can use to recap the monthly total of days worked based on the color shading
of the date fields? For example, if I work M-F this week, but only M-Th next
week, and my work days are white, can I have a cell that shows me that I
worked 9 days total in this 2 week period?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF OR AND in same conditional formula 2
sum total of numbers that are a certain color? 3
Calendar, if paid on date, not count prior 2
Hide text in shaded cell 3
SUMPRODUCT to count cells with background color 3
Formula for a time card 6
Conditional Formating Same Color as Form Background 3
Conditional formatting: how to use OR for names? 1

Top