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.