conditional formatting across worksheets

**martindwilson** · 11-01-2008, 06:04 PM

define a name for your accepted names range say "nameslist"(use insert/name/define/refers to
='Accepted Names'!$A$2:$A$9)
then cf condition 1 formula is
=MATCH(A2,nameslist,0)
green
condition 2
=ISNA(MATCH(A2,nameslist,0))
red
warning i see from your example that some names arnt the same length
so use trim
=MATCH(TRIM(A3),TRIM(nameslist),0)

**jcavigli** · 11-01-2008, 06:17 PM

I will definitely have to use that trim function, the names will not have the same string length. Let me try this stuff out and get back to you.

**jcavigli** · 11-01-2008, 06:53 PM

I used formulas 1 and 2 on the 'Enter Data Here' worksheet. I am applying them to the range A2:A1000. (I would like to apply it to the whole column later on)

For some reason some names come back black? I must be doing something wrong. I have attached my sample with your formulas.