|
|
#8
07-27-2011, 07:51 PM
|
|||
|
|||
Just add new rule, select the range A4:C100, open conditional formatting, add new rule, select to use formula, and the formula to format is:
=sum(H4:Q4)<0, and the color to format is obviously, grey 
|
|
|
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 Vista 
Office 2007
Threaded Mode