Hi Tom,
Use double quotes.
$Sheet1.$I13 = "N"
tc
tom wrote:
-=_Part_25157_15858549.1130714727510--
Thanks. That worked, but it brought up another problem. I first tried
the formula $Sheet1.$I13 <> 'Y', but it didn't work so I figured that
maybe it didn't like the <>, so I broke down the three cases: (blank),
'Y', and 'N' and used equals signs. 'N' and blank were supposed to
yield one style and 'Y' the default style. Blank yielded the correct
style. Y yielded the correct style, but since it is the default style I
wouldn't know whether it failed, and 'N' yielded the default style, even
though it was supposed to yield a different style. I have a feeling
that I am putting in the literal values incorrectly. The equation I
used was the following:
$Sheet1.$I13 = 'N'
Can you tell me how to correct it so that when the program sees a
capital N in cell I13 it changes the style to my desired value?
Thanks,
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
