I couldn't get that formula to work so that they would all stay grey if H4:Q4<0, so I turned it around and made it so they would be no-fill if H4:Q4>0. This worked for the most part (I just auto-filled all the cells grey so that they would change to no-fill when data was entered), except for columns H, I and J. When data is entered into column H, only column A changes; when data is entered into column I, only column B changes; for column J, only C changes. Any suggestions on how to make the first formula work or fix the problems with columns H, I and J?