How does this Conditional Format work?

		Microsoft Office Forums > Microsoft Excel > Excel
How does this Conditional Format work?

FAQ

Thread Tools

Display Modes

04-16-2014, 10:09 AM

Gary Drumm Gary Drumm is offline

Windows XP How does this Conditional Format work?

Office 2007

Advanced Beginner

Join Date: Mar 2012

Posts: 86

Safer? In this case, it is referencing numbers only.

But can you explain further, and give me a couple of examples of such error values, logical values and arrays?

I don't think I will get in that deep, but what might be an expected outcome?

I'll give the =TYPE()=1 a try.

=((TYPE(H4)<>2)*(H4<>""))*OR(H4<$E4,H4>$G4)

How would apply your suggestion to this formula?

Thanks,
Gary

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:58 AM.