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)

"will07" wrote in message
...
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