View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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.