Conditional Formatting for Variance - Forecasted and Actual Dates

I have a set of forecasted and actual dates for different projects.

I want to be able to apply conditional formatting to the actual dates that fall before the forecasted date (in green) and after the forecasted date (in red)

See the attached file

This is an example data set

Capture1.PNG

So it should look like this with the formatting

Capture2.PNG

Of course I have about pairs of forecasted and actual dates and about 80 on-going projects.

I’ve created a column with the variance values and have tried to create rules using the variances as reference for the formatting.

Where $BB$5:BB$74 is the column with the variance between the pair of forecasted and actual dates.

Capture3.PNG

And where$H$5:$H$74 is the column of the Actual date, the column that I want the formatting on

Capture4.PNG