hi
it is possible to have multiple formats in a cell but only with static data
such as text or numbers stored as text. It is not possible with data that
changes or may vary from time to time such as number, dates and formulas.
reason. to have multiple formats requires specific start and stop points
within the cell. formula could have a few characters to many many characters
but only return a single digit on monday and 10 digits on friday. date change
daily. at the beginning of the month a data may be 8 characters and at the
end of the month, 10 characters. the specific start and stop points do not
adjust as data changes so it is not possible to have multiple formats with
formulas, dates and numbers.

sorry
regards
FSt1

"STRAC" wrote:

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?