I'm sorry, I was not very clear. I have no interest in negative numbers; when I said I wanted A4:C4 to turn grey when H4:Q4<0, I actually meant that I wanted A4:C4 to be grey only if there was no data entered in H4:Q4 (so greater than or equal to, i guess). So pretty much whenever I put a number into the range of H4:Q100, I want the columns A, B and C from the respective row to turn from grey to no-fill
|