How does this Conditional Format work?

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

FAQ

Thread Tools

Display Modes

04-11-2014, 10:05 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

How does this Conditional Format work?

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

I had help getting this conditional format, which highlights a cell if its' contents fall outside a min. max range on the spreadsheet.

I really don't understand how it works though.

Can someone explain it to me please?

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 11:37 AM.