Help needed in formula

[cammy99]

Hi All,

I truly appreciate if you can help me on my problem as per example below.

Item-A			Item-A	no Yellow
Blue			Item-B	no White
Green			Item-C	no Red
Red
White
Yellow	FALSE
Black
Item-B
Green
White	FALSE
Red
Pink
Yellow
Black

<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>

How do i formula it to show me the wrong color in each item?

plsssss help

 

[cammy99]

And is there a way to link the formula with the list of data telling me which item not allowed which color?

 

[cammy99]

	A	B	C	D	E
1	Item-A			Item-A	Yellow
2	Blue			Item-B	White
3	Green			Item-C	Red
4	Red
5	Yellow	TRUE
6	Black
7	Item-B
8	Green
9	White	TRUE
10	Red
11	Pink

<tbody>
</tbody>

 

[cammy99]

help pls?