Sumproduct + validate dates + color cell if older as specific date.

**dutchdog** · 10-05-2012, 09:03 AM

So I have this code

Please Login or Register  to view this content.

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 update dates results if there are any older than 1 day from current date and if so, make the cell background color with his results red.
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
2. Return that value as a number in sheet results in a specific cell
3. Make that cell red if any of his callbacks update dates are older as 1 day

How do I do that adding to above code? Tricky maybe?

**dutchdog** · 10-05-2012, 09:13 AM

Adding to this, I would also like a code that checks the data sheet and makes all "open - callbacks" from any username older as 1 day, red based on the date.

**dutchdog** · 10-05-2012, 10:51 AM

Originally Posted by dutchdog

Adding to this, I would also like a code that checks the data sheet and makes all "open - callbacks" from any username older as 1 day, red based on the date.

I solved this with conditional formatting. Only query 1 remains.