giacomo
Well-known Member
- Joined
- Feb 20, 2002
- Messages
- 1,796
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
=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