Use :
=IF(M71="Yes","No","TBC")
and use conditional formating to test the cell value.
HTH
Daniel

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?