View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
STRAC STRAC is offline
external usenet poster
 
Posts: 13
Default Formatting color and font to a logical statement result?

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?