why does this RGB function not work? (sample now included)

[amien]

=IF(NodeActive='N',RGB(10,10,10),RGB(70,130,180))

i only see the second color in my dimensions.

When i select only the NodeActive=J in a listbox .. then i only see the first color. But with no selection i see only the second color.

Thanks in advanced

[amien]

with L2 i do

=IF(aggr(minstring(Active_Hier),HQ, L2)='No',Red(),White()) .. right? i always refer to the first dimension?

what if Active_Hier contains two options .. and i want to prefer one of the options ..

so if active_hier has two options, when the cell should be white() .. if there is one option and the value is 'no' then it should be red. if there is one option and this option is 'yes' can bg-color is red.

so really .. if there is only 1 option and that option is red, when bg-color is red. in all other cases it should be white