2008-04-05 14:58:00 UTC
been applied to a shape?
Specifically, I'm trying to determine whether a color by value DG has been
applied. I know that color by value creates Uesr.visDGCBVFill and then
deletes it when you remove the DG. It would be logical to test for existence
of that cell, but there is no CELLEXISTS() function in the shapesheet. I
tried using FORUMULAEXISTS(User.visDGCBVFill) but as soon as I remove the DG,
this becomes FORMULAEXISTS(REF()).
I also tried a forumula David Parker posted a year ago in response to a
but this always returns a value of 1.