Anthony Chilco <[EMAIL PROTECTED]> wrote in news:43657463.6020001 @chilcostreet.ca:
> 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 >> It worked! Thanks to both of you. --Tom >> >>--------------------------------------------------------------------- >>To unsubscribe, e-mail: [EMAIL PROTECTED] >>For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> > > Attachment decoded: text-plain-2 > --------------030208050004030803000106-- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
