View Single Post
 
Old 07-28-2011, 08:44 AM
avanderh avanderh is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jul 2011
Posts: 6
avanderh is on a distinguished road
Default

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
Reply With Quote