In Conditional Formatting, select "Formula Is", and try this:

=OR(A1="",COUNTIF(A1,"*missing*")0)

Assumes "missing" may be combined with other text in the same cell.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"watermt" wrote in message
...
I'm attempting to do some conditional formatting on text. I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?