[Jon]

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?

[David Biddulph[_2_]]

Look up "conditional formatting" in Excel help.
--
David Biddulph

Jon wrote:
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?

[Daniel.C[_3_]]

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?