I need a formula which will look at cell D3, and if the formula has returned
a number then execute the following code:

Range("D9:F9").Select
Selection.Interior.ColorIndex = 35