Date formatting

[Conor Powell]

Hi all,

Looking for some help on here. 

I have a 'complaints tracker' that I have produced for work. In column B I have dates of when a complaint was sent to us. In column H I have the dates that the complaint was completed. I'm looking for a formula that, will show me....if the date in column H is greater than the date in column B by 2 weeks, it will show up red. And then if column H is less than column B by 2 weeks it will show green. 

Is this possible at all? 

I have worked out the conditional formatting that is already on excel, however I cannot drag the formatting down the column as the dates that I am formatting will be different from the one before. 

Thanks

[#2]

Hi Conor,

You may use conditional formatting rule with formula

=$H1>=$B1+14

for the red. and similar for the green, applied to your column H (or your range with dates within it, when instead of $H1, $B1 it shall be reference on cells in first row of the range)