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
Counting number of cells until a criteria is met 0
Highlighting multiple triggers 4
Splitting a number in one cell into other cells 0
sum total of numbers that are a certain color? 3
Calculating calendar days and completion dates. 4
Calculating Dates Using Different Values for NETWORKDAYS 9
Calendar, if paid on date, not count prior 2

Top