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?

So:

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)

Hi, why can't you add a dummy workbook to understand your requirement better?