Hello,

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?

Thank you very much in advance,
Marcel

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-

With the built-in capabilities of conditional formatting, you can't
distinguish between values and formulas in a cell.

You could use programming to format the cells, by using event code that
runs when a cell is changed.

Marcel Marien wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Marcel

Not sure what you're looking for here.

Do you want to base the CF on whether or not the cell has a formula or just
contains text/number?

Or do you want to check if the cell contains a formula with a specific cell
reference or any cell reference?


Gord Dibben MS Excel MVP

On Sun, 29 Oct 2006 00:13:10 +0200, "Marcel Marien" wrote:

Hello,

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?

Thank you very much in advance,
Marcel

hi, Marcel !

see replies to your post in excel ng

[and... *try* NOT multi-posting, but cross-posting] ;)

regards,
hector.

__ original post __
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?

Hello Gord,

I want to base the conditional format on whether or not the cell contains
any cell reference or rather a text/value.

Marcel


"Gord Dibben" <gorddibbATshawDOTca schrieb im Newsbeitrag
...
Marcel

Not sure what you're looking for here.

Do you want to base the CF on whether or not the cell has a formula or
just
contains text/number?

Or do you want to check if the cell contains a formula with a specific
cell
reference or any cell reference?


Gord Dibben MS Excel MVP

On Sun, 29 Oct 2006 00:13:10 +0200, "Marcel Marien"
wrote:

Hello,

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?

Thank you very much in advance,
Marcel

hi Héctor,

sorry, if I didn't comply to the rules of the group here. Can you tell me
what is "cross-posting"?

Thanks
Marcel


"Héctor Miguel" schrieb im Newsbeitrag
...
hi, Marcel !

see replies to your post in excel ng

[and... *try* NOT multi-posting, but cross-posting] ;)

regards,
hector.

__ original post __
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?

Marcel

Cross-post is when you post one message with several news groups in the
"newsgroups" dialog.

microsoft.public.worksheet.functions,microsoft..pu blic.excel,microsoft.public.excel.misc

Note the comma between each group.

All the regulars monitor all the Excel news groups, so if the topic is Excel, no
need to post to more than one group.

Although I should amend that..........the programming group is strictly for VBA
so if you have a VBA question you would be best posting to that group.

Multi-posting is when you post similar messages singly to each group.

Those of us who use real newsreaders can pick up the cross-posts and flag them.

No way to flag multi-posts.


Gord Dibben MS Excel MVP

On Thu, 2 Nov 2006 01:14:58 +0100, "Marcel Marien" wrote:

hi Héctor,

sorry, if I didn't comply to the rules of the group here. Can you tell me
what is "cross-posting"?

Thanks
Marcel


"Héctor Miguel" schrieb im Newsbeitrag
...
hi, Marcel !

see replies to your post in excel ng

[and... *try* NOT multi-posting, but cross-posting] ;)

regards,
hector.

__ original post __
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?

Marcel

You can CF the cell if it contains a formula like =A1 or =Sheet1!A1

Store this UDF in your workbook in a general module.

Function IsFormula(cell)
IsFormula = cell.HasFormula
End Function

In CF use Formula is: =IsFormula(cellref)

If the cell contains just A1 with no = sign then I can't help.


Gord


On Thu, 2 Nov 2006 01:13:24 +0100, "Marcel Marien" wrote:

Hello Gord,

I want to base the conditional format on whether or not the cell contains
any cell reference or rather a text/value.

Marcel


"Gord Dibben" <gorddibbATshawDOTca schrieb im Newsbeitrag
.. .
Marcel

Not sure what you're looking for here.

Do you want to base the CF on whether or not the cell has a formula or
just
contains text/number?

Or do you want to check if the cell contains a formula with a specific
cell
reference or any cell reference?


Gord Dibben MS Excel MVP

On Sun, 29 Oct 2006 00:13:10 +0200, "Marcel Marien"
wrote:

Hello,

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?

Thank you very much in advance,
Marcel