I have a spreadsheet with columns A-K and rows 1-56. If any value in D3 through J3 goes below 0, I want the entire row (A through K ) to have a special format. I've gotten close in Excel 2010 by using the *Home ->Conditional Formatting->Manage Rules->New Rule* and I created a formula rule where the Formula is

```
=($D3:$J3)<0
```

and in the *Applies to* I have
=$A$3:$K:$56

What happens now is it works great for any value in Column D **ONLY**. When values in E-J change I get no formatting. Anybody know why?