|
|
#3
04-16-2014, 03:24 AM
|
||||
|
||||
It's basically equivalent to:
=AND(TYPE(H4)<>2,H4<>"",OR(H4<$E4,H4>$G4)) or: =(TYPE(H4)<>2)*(H4<>"")*((H4<$E4)+(H4>$G4)) or: =AND(TYPE(H4)<>2,NOT(ISBLANK(H4)),OR(H4<$E4,H4>$G4 )) gebobs: ISBLANK(H4) is not equivalent to H4<>"", but NOT(ISBLANK(H4)) is.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional Format cell appearance Excel 2007
|
Gary Drumm | Excel | 3 | 02-22-2014 01:43 AM |
|
Applying a conditional format to multiple rows
|
secoo140 | Excel | 1 | 10-12-2013 07:19 PM |
| Table with Conditional Format to Word | billyV | Excel | 9 | 06-07-2013 08:26 AM |
| Copy format created by a conditional formatting | spk | Excel | 2 | 04-10-2013 04:41 AM |
|
Conditional format for form drop-down list?
|
pmregan | Word | 1 | 09-19-2012 07:09 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode