Thanks, but a conditional format would always be in place. I am setting this
up to initially set the range color but need to be able to change the color
down the line.

"Jezebel" wrote in message
...
Use Conditional formatting ---

Select cells D9 to F9. Go to Format Conditional Formatting

In the first drop-down select "Formula Is".

In the text box, enter: =IsNumber($D$3)



"Patrick Simonds" wrote in message
...
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