Creating a simple map(?) chart from a table

[Carl_London]

Hi all

I have a simple list shown below at Sheet 1. Column A represent a series of 'Areas' and Column B a series of names.

I want to produce a 'map like' visual like Sheet 2 where an area is formatting green if they is a value in Column B of Sheet 1. If there is no value in Column B of Sheet 1 the cell on Sheet 2 should remain unformatted.

Sheet 1

Sheet 2:

Grateful for any help please.

Thanks

Carl

 

[awoohaw]

how about this:

Book1
	A	B	C	D	E	F	G	H	I	J
1	Area	Name
2	A1
3	A2	John
4	A3
5	A4
6	A5	John		A1	A2	A3	A4	A5		A7
7	A7	Frank			B2	B3	B4	B5
8	B2					C3	C4	C5	C6	C7
9	B3	Mary			D2	D3	D4	D5	D6
10	B4
11	B5
12	C3
13	C4	Linda
14	C5	Linda
15	C6
16	C7	Joe
17	D2
18	D3	Sam
19	D4	Sam
20	D5	Sam
21	D6
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D6:J9	Expression	=D6<>""	text	NO
D6:J9	Expression	=AND(D6<>"",INDEX($B$2:$B$21,MATCH(D6,$A$2:$A$21,0))<>"")	text	NO

 

[Carl_London]

Thank you for your quick reply. I will have a play this evening.

All the best, good weekend

Carl

 

[awoohaw]

You're welcome. Note, I did all on one sheet. Also, the conditional formatting dialog (as far as I can see) cannot change the border thickness.