Conditional Formating a cell .. to Show Nothing .. if True

[monir]

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.

 

[Guest]

Hi

Try
=ISTEXT(M9)

Hope this helps.
Andy.

 

[Guest]

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

Andy.

 

[monir]

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

 

[Guest]

Hi

In your example, you'd have to set the fill colour to white also.
With regard to pasting, I would suggest you record a macro while you CF the
columns. Once you have imported the data, you ccan just run the macro to CF
the cells.

Andy.