How to color results, based on a sumproduct that then compares dates also?
So I have this code
[Select Code] copy to clipboard
=sumproduct((Data!$B$2:$B$4992="WI5608")*(Data!$B$2:$B$4992="Open - Callbacks"))
Which validates how many open callbacks user WI5608 has and displays that value as a number.
Now I want to check of those open callbacks if there are any older than 1 day from current date and if so, make the cell background color with his results red if that particular user has callbacks older as 1 day in his total results.
The dates are in column E of sheet "Data".
So code must do this.
1. Check how many "open - Callbacks" user WI5608 has in sheet data (it allready does that)
2. Return that value as a number in sheet results in a specific cell (it allready does that)
3. Make that cell red if any of his callbacks update dates are older as 1 day, make cell green if not older as 1 day in his Q.
How do I do that adding to above code? Tricky maybe?
WI5608 ---> 17 (User WI5608 has 17 callbacks but none of them older as 1 day)
BA7804 ---> 5 (user BA7804 has 5 callbacks of which at least 1 that is older as 1 day)
Valued Forum Contributor
Re: How to color results, based on a sumproduct that then compares dates also?
Hi, why can't you add a dummy workbook to understand your requirement better?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1