In , Marcel Marien
spake thusly:

is it possible to format a cell conditionally in such a way, that
the content appears in a certain format if the cell contains a
value or text and in another format if the cell contains the
address of another cell?

Um. Yes, it's possible.

See Tools - Conditional Formatting on your Menu bar.
And look for some threads here in this group with the words
"conditional format" or "formatting" in the Subject.

-dman-