"so if it were multi-column and row, it would need to return two values." <
WHICH IT CAN'T !! Right?
Sorry to be so thick (here),,
Appreciate your contribution to this (an other excel) group(s).
Jim

"Bob Phillips" wrote in message
...
Hi Jim,

Yes, MATCH is single column/row, it returns an index into that array, so
if
it were multi-column and row, it would need to return two values.

--
HTH

Bob Phillips

"Jim May" wrote in message
news:iGYOe.432$8q.32@lakeread01...
Bob,
Does Match() only work where you are comparing 1 column (sheet1) against
another single column(sheet2). I tried entering data on sheet2 in
columns
b, c, and d (also including in my "myrange"), but nothing turns red now
on
my sheet1.
TIA,
Jim

"Bob Phillips" wrote in message
...
There is.

Add a name for the range of data on sheet 2, say myRange

Select all the cells on Sheet1

Change the Condition 1 value in CF to Formula Is

Add a formula of =NOT(ISNA(MATCH(A1,myRange,0)))

Click Format, select pattern and choose red

OK out

--
HTH

Bob Phillips

"murphyz" wrote
in
message ...

Hello all,

I have a spreadsheet with 79,000 cells of information in rows and
columns. On a separate worksheet I have 5,000 cells of information.

I would like any information in the first sheet that is in the second
sheet to turn to red.

For example.

Sheet1, column A
hellothere
howareyou
iamfine

Sheet2, column A
hellothere
iamfine

I would like the two strings in sheet one which appear in sheet 2 to
turn red, leaving the middle string black.

Is there a way to do a lookup to compare the cell value to a range
using conditional formatting?

Thanks for any help.

Mxx


--
murphyz

------------------------------------------------------------------------
murphyz's Profile:
http://www.excelforum.com/member.php...o&userid=20624
View this thread:
http://www.excelforum.com/showthread...hreadid=398508