Need assistance with rolling 30 formula to identify a value

[kabob]

Hello, thank you for reading this inquiry. I am trying to create a formula that will find a particular value in a rolling 30 days, and highlight the cell red. I have been working on this formula for a few days, and decided to ask for help. The example, is a simple time card in which I need to know if there was an employee who worked 12 or more hours on a particular task, in a rolling 30 days. I created a vlookup to identify the tasks I need to monitor, but I can't seem to figure out how to create the rolling 30 days to identify a particular value. The formula doesn't need to sum anything, it only needs to highlight the cells in red that return a result of 12 or more.
Thank you in advance for your help.

 

[Hui]

@kabob

Firstly, Welcome to the Chandoo.org Forums

First, teh Dates in Row 3 are Text, Not Dates
Retype then as Dates eg: 8/10 Enter or maybe 10/8 if your in the US

Select range B4:H13
Apply a Conditional format, using a Formula

=AND(B4<>"",SUMPRODUCT(($A$4:$A$13=$A4)*($B$3:B$3<=B$3)*($B$3:B$3>=(B$3-30))*($B$4:B$13))>0.5)

set a Format
Apply



or see attached file