Conditional Formating a cell .. to Show Nothing .. if True
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.
|