Problem with Conditional Formatting

		Microsoft Office Forums > Microsoft Excel > Excel
Problem with Conditional Formatting

FAQ

Thread Tools

Display Modes

03-25-2012, 01:19 AM

Pecoflyer

Windows 7 64bit Problem with Conditional Formatting

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

What is the FALSE for in

Code:

=ISERROR(MATCH(B2,INDIRECT(SUBSTITUTE(A2," ","")),FALSE))

I thought the switches for MATCH were 1,0 and -1?

__________________
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 formatting	zanat0s	Excel	4	01-20-2012 03:30 AM
Conditional formatting with AND, OR	Lucky	Excel	2	10-03-2011 11:41 PM
Conditional Formatting	namedujour	Excel	3	08-25-2011 01:46 PM
Conditional Formatting Problem Excel 2007	namedujour	Excel	6	08-04-2011 10:52 AM
help with conditional formatting	Snvlsfoal	Excel	3	07-03-2011 11:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:41 PM.