Hello,

The scenario is as follows: A shape's background color may be toggled from red to blue (and vice versa) by its context menue. This works fine.

The formula in User.toggle is =IF(RED(FillBkgnd)=255,TRUE,FALSE)

The formula in User.time is =IF(User.toggle,MODULUS(SECOND(NOW()),2)=1,"xyz").

So the fomula calculated if the change to red happened in a even or uneven second. This works as well.

The formula in User.time.Prompt is =IF(User.time,"odd",IF(NOT(User.time),"even",IF(User.time="xyz",**0,0**))).

In case the shape's background turned to red the formula calculate correctly but when it turns to blue the result is **#Value!**.

Also =IF(User.time,"odd",IF(NOT(User.time),"even",**0**)) gives the result #Value!.

Why it doesn't calculate **0**?

I didn't try to solve this with ISERRVALUE yet. May I?

Googeling "visio shapesheet result error "#Value!" " doesn't give lots of matches, so I'm a bit clueless.

Does someone has an idea (or even better: a solution)?

Thanks and have a nice weekend

hl