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, 12:01 PM

Pecoflyer

Windows 7 64bit How does this Conditional Format work?

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Perhaps this is a bit simpler

Code:

=isnumber(h4)*OR(H4<$E4,H4>$G4)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« 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 10:57 AM.