If the CF "Formula Is = IsText(D4)" is True, one may change the font colour
in D4 to match the cell colour. But, the fill colour in D4 varies for each
run of the same w/b depending on certain computations!

Basically, here is what we're trying to do: if the value in D4 is text, then
don't show the value, and if it's a numerical value, then change nothing.

Further, you're correct! If the value is pasted into D4, rather than entered
manually, the CF in D4 would be deleted!

Any suggestions? Thank you.

cell colour

"Andy" wrote:

Forgot to mention that this does not work when the cell is pasted into. The
format from the copied cell will override.

Andy.

<Andy wrote in message ...
Hi

Try
=ISTEXT(M9)

Hope this helps.
Andy.

"monir" wrote in message
...
Hello;

If the value in cell M9 (entered or copied to) is text (or non numeric),
then don't show the value (leave the cell blank). I couldn't use the fill
and
font colour formating if the condition is true, because the cell fill has
a
different fill / font colour combination for each run of the w/b.

Could you please show me how the Conditional Formating "Formula Is ="
would
look like in cell M9 ??

Thank you kindly.