|
|
|
|
#1
07-03-2011, 12:35 PM
|
||||
|
||||
You can use the AND() worksheet function:
=AND(D6<40,E6>0) It returns TRUE if both conditions are met. 
|
|
#2
07-03-2011, 11:55 PM
|
|||
|
|||
|
Yes, thats nicer.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 * Conditional Formatting MS 2010
|
djreyrey | Excel | 3 | 06-03-2011 01:54 AM |
| Conditional formatting of Today +21 days? | SHERMAN | Excel | 3 | 12-20-2010 08:08 AM |
|
Conditional formatting of cell, Excel 2003
|
Scaffold | Excel | 2 | 05-01-2010 08:56 AM |
| Challenge!! Need help though. (Conditional formatting) | knuckles70 | Excel | 2 | 02-05-2010 12:24 PM |
| Conditional Formatting to Hide Rows or Columns? | sczegus | Excel | 0 | 09-26-2006 04:17 PM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode