How does this Conditional Format work?

macropod · #1 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.

gebobs · #2 04-16-2014, 03:49 AM

Quote:

Originally Posted by macropod

gebobs: ISBLANK(H4) is not equivalent to H4<>"", but NOT(ISBLANK(H4)) is.

Hah...of course.

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