Hello-
I have Column A that is conditionally formatted to a Red Fill if the date is between 6PM of the previous day and 6AM on the current day. Is there anyway to count the red cells.
Thanks
Clik
Hello-
I have Column A that is conditionally formatted to a Red Fill if the date is between 6PM of the previous day and 6AM on the current day. Is there anyway to count the red cells.
Thanks
Clik
What is that conditional formula?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
You cannot directly count cell colors without using VBA, but I infer from NBVC's question that he will lead you to using something like COUNTIFS using the same condition you use to set the colors.
Yes, that is where I was leading...
How do I copy a conditional format so I can paste it? I just used the conditional format rule creator on the ribbon. In the rule creator I selected Highlight Cells>Between>03/01/2010 7:00PM and 03/02/2010 7:00 AM.
What I am trying to do is get a count of the # of Voicemails or Emails that come in after business hours.
The Workbook has 2 worksheets 1st called DATA and Column D of DATA = Call Type that has three options VM, EMAIL or ACD. 2nd called Report which is where I want the count to be.
He already gave you the conditional formatting
"...conditionally formatted to a Red Fill if the date is between 6PM of the previous day and 6AM on the current day"
So you need to Count the number of line that have a date between 6PM (previous day) and 6AM (current day)
Use CountIf/CountIfs and make your criteria equal to the conditional formatting.
Last edited by DP978; 03-03-2010 at 12:39 PM.
Something like
=Countifs(Range,">03/01/2010 7:00 PM",Range,"<03/02/2010 7:00 AM")
where Range is the range to count within...
If you want to automatically use yesterday and today's dates... each time you look at the sheet.. then
=COUNTIFS(Range,">"&TODAY()-1+TIME(19,0,0),Range,"<"&TODAY()+TIME(7,0,0))
Last edited by NBVC; 03-03-2010 at 12:59 PM.
Ok That works, thanks.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
rule # 2 ..........
Last edited by Ou812eh; 03-25-2011 at 11:18 PM. Reason: rule
John
Marie von Ebner-Eschenbach - "Even a stopped clock is right twice a day."
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks