excel conditional formatting

HansVogelaar Thanks to your answer, I was able to arrive at a solution. Here was my solution:

First you must select the entire range that you want involved. Normally in my case I don't know how many rows I'm going to need so it would be best to select enough that you think you will be covered. I will select a range covering 1000 rows.

Select A1:D1000        This is the range I want to change color

Select "Conditional Formatting"

Select "New Rule"

Style: Select "Classic"

Select "Use formula to determine which cells to format"

Enter formula: =$D1>0    This is the cell that I want to change color of range A1:D1 when a number >0 is entered in D1.

Select "OK"

Result:

If I enter a number >0 in any cell in column D up to D1000 it will format the corresponding row.

Thanks again!