|
|
#9
07-28-2011, 08:44 AM
|
|||
|
|||
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
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I fill the below emty cells with above cell data? | Learner7 | Excel | 8 | 06-28-2011 12:10 PM |
 Conditional data validation (list drop-down)
|
click4akshay | Excel | 2 | 04-28-2011 01:51 PM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
|
Conditional Expression that Moves Data (challenging)
|
themangoagent | Excel | 1 | 02-20-2010 11:29 AM |
|
Change Automatic Fill Color
|
Leanne | PowerPoint | 1 | 11-04-2009 08:34 PM |
Windows 7 32bit 
Office 2007
Threaded Mode