Assign logic to FillForegnd

[MDelisle]

I have expect to use some logic to assign color to rectangle depending if the
object
is "in scope", "limited" or "out of scope", I have put the following
statement under the Fill format.FillForegnd cell found into the shapesheet
but this doesn't seem to work. The statement added is "=IF(Prop.INSCOPE="IN
SCOPE",3,IF(Prop.INSCOPE="LIMITED",RGB(255,204,102),RGB(150,150,150)))"
The logic seem to recognize only the first IF statement. What I do wrong?

If I put 3, RGB(255,204,102) or RGB(150,150,150) alone, I got the color asked.

Thanks in advance.

 

[MDelisle]

Actually, I have noted also that it is only the True condition that is
selected even if the condition is false.

 

[Mark Nelson [MS]]

Try using the STRSAME function to compare strings rather than '='. Use '='
to test numeric values.

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[MDelisle]

Thank you this work!!

Try using the STRSAME function to compare strings rather than '='. Use '='
to test numeric values.

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.