Hi,

Use conditional formattting.

Select the cell with the formula in then:-

Format conditional formatting
Select 'Formula is'
enter the formula
=C28+C41=0

Pick a font colour

OK

Mike

"Martin" wrote:

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