View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Jon is offline
external usenet poster
 
Posts: 183
Default Different color on cell [newbie]

I would like that text is displayed in a different color, in the following
example, with the following conditional (i.e. if it evaluates to false
display text in red):

=IF(M71="Yes","No",[Red]"TBC")

Any ideas?