Apply confidtional formatting to differed filtered ranges

[wayneknox01]

Hi,

I have a large workbook with certain groups of cells (defined by filters) and want to apply different conditional formats based on those ranges.

For example:
A: B:
Region 1 10/02
Region 3 12/04
Region 2 15/03
Region 1 11/02
Region 2 12/03
Region 1 15/02
Region 3 10/04
Region 2 14/03
Region 3 13/04

If the dates for region 1 = between 10/02 and 11/02 then make blue
If the dates for region 2 = between 14/03 and 15/03 then make blue
If the dates for region 3 = between 13/04 and 14/04 then make blue

I'm struggling because the list filters around 1000 lines and so I don't know how to only limit a certain conditional format to only that group.
Does anyone know how I can achieve this?

Thanks.

 

[wayneknox01]

Any suggestions guys?