Select the entire range, go to FormatConditional FormattingCell Value
IsEqual To"INVALID". Click on format and choose the pattern and font
style.

Thanks

"STRAC" wrote in message
...
How do I format color and font to a logical statement result?

For example my formula is: =IF(M199360,"INVALID","OK"), I want the
"INVALID"
to really stand out on the spreadsheet by bolding it and changing the
default color to red. Is there a way to do this?