Conditional Format Question

[will07]

Is it possible to add text as part of the format, as well as changing the
Font/Cell colour.

At the moment the format is set to change the cell colour when 2 opposing
cells differ, but I need to show text as well as a colour change.

Thanks

 

[Bob Phillips]

Not directly. You could maybe use event code to trap the change and then add
a format that adds the text (if it is numbers that is).

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)