conditional formating based on value in named range

[Nico]

Hi,

I would like to use conditional formating based on an cel value being
present in a named list.

for example :

A1 : contains the value "w"

a named list (lets call it B_list) exists like :

B1 : r
B2 : q
B3 : s
B4 : w

As a formula in conditional formating I would do something like :
if(A1 in B_list)
but I think there must be something wrong in the way I think.
Can someone help me with this ?

Thanks,
Nico

 

[Bob Phillips]

Select all the cells(say A1:A100)

In CF, change condition 1 to Formula is, and add a formula of

=ISNUMBER(MATCH(A1,B1:B4,0)), then format

OK out

 

[Bob Phillips]

Slight formula amendment for the name

=ISNUMBER(MATCH(A1,B_list,0)),

 

[Frank Stone]

hi,
not sure but check these sites
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/CFColors.htm
Regards
Frank

 

[Frank Stone]

hi,
not sure but check these sites
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/CFColors.htm
Regards
Frank