Hello, I just posted this question but it wasnt quite correct, here is the
new question.

I have the following calculation in a cell:

=IF(qryData!CI37 = 0, TREND(D28:D34,$B$28:$B$34,$B$35,1), qryData!CI37)

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.
qryData!CI37 is not equal to 0.

I have tried the conditional formatting but it doesnt seem to work

Many thanks,

Martin