Hello,

I have the following calculation in a cell:

=IF(C28+C41 = 0, TREND(C9:C15,A9:A15,A16,1),C28+C41)

This is to use the trend function if the cell value is 0, this works fine.
What I would like to do however is to colour the font in red if the trend
function is being used but leave as black if there is actual data there i.e.
C28+C41 is not equal to 0.

I would really appreciate knowing how to do this.

Many thanks,

Martin