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