Lookup date row and count cell by specific colour given

[GR_COOPER]

Hi Guys,

I'm stuck and could do with your help. I've used the Excel help and 'googled' this until my hair falls out but to no avail.

Windows 7
Excel 2007

I would like to create a formula in Excel that when a specific date is input in a given cell, excel will LOOKUP that date row in a given worksheet and return a count of a specific colour in that row.

I have managed to use the 'Countcellsbycolour' VBA script but don't know how to use this alongside a date lookup as well.

I have produced a basic template which explains the detail. Please be aware it contains the VBA script for 'Countcellsbycolour'.

https://dl.dropboxusercontent.com/u/48440645/test.xlsm

Any help would be massively appreciated.

Thanks,
Gavin