Conditional Formatting Troubles

[giacomo]

I am using the following conditional format to bold certain cities that match to 4 specific cities:

=MATCH(A1,CityList,0)

where CityList is a named range that refers to cells $D$3:$D$6, the data contained in those cells are the following 4 city office names:

Bakersfield
Tucson
SonomaMarin
Austin

This is working great with the exception of SonomaMarin, it bolds the other cities but not this one.

I'm using excel 97 on windows NT.

Thanks for your help,
giacomo

[Brian from Maui]

Try checking for any extra spaces in your list and/or in A1

[giacomo]

On 2002-04-29 11:12, Brian from Maui wrote:
Try checking for any extra spaces in your list and/or in A1

Thanks for your reply, no additional spaces, I should have mentioned that in my post. I even checked the two using the EXACT formula and the result is TRUE.

Also, when I use the MATCH formula in a cell, instead of within Conditional Formatting it gives the right result.

[ This Message was edited by: giacomo on 2002-04-29 11:20 ]

[bergy]

It works okay for me. Why don't you re-define your list? Maybe Sonoma\Marin didn't make the list properly.

[giacomo]

On 2002-04-29 11:22, bergy wrote:
It works okay for me. Why don't you re-define your list? Maybe Sonoma\Marin didn't make the list properly.

Thanks, I tried your suggestion but it didn't help. I even tried replacing the list with the cell reference instead but that didn't help either.

Thanks,
giacomo

[Brian from Maui]

How's about

=countif(range,a1)>=1

[bergy]

Maybe it's an NT issue. I'm not up on NT, but could the '\' be causing the problem? Maybe NT thinks its a looking for a networked computer and not a string. Could you manually replace the '\' in CityList with a '-' and then do the same replacement in column A and see if it finds it then?

[Aladin Akyurek]

On 2002-04-29 11:04, giacomo wrote:
I am using the following conditional format to bold certain cities that match to 4 specific cities:

=MATCH(A1,CityList,0)

where CityList is a named range that refers to cells $D$3:$D$6, the data contained in those cells are the following 4 city office names:

Bakersfield
Tucson
SonomaMarin
Austin

This is working great with the exception of SonomaMarin, it bolds the other cities but not this one.

I'm using excel 97 on windows NT.

Thanks for your help,
giacomo

Apply LEN to the target entry in the CityList:

=LEN(D5)

and do the same wrt to the entry in the range where you apply cond format.

Are they equal?

[giacomo]

Brian from Maui & bergy,

Thanks for sticking with me on this. I discovered the problem and it had nothing to do with my MATCH formula. I've been using conditional formatting to highlight every even numbered row in my worksheet, it just so happens that SonomaMarin was my only matching city that was on an even row.

Once I removed the other conditional format it worked fine. Any ideas on how I can get the two to work together?

thanks!
giacomo

[Brian from Maui]

Aladin can!

What order do you have the formatting?