Hi

I am a new user to this site and I have been stuck on this issue for a day now. I want to use the following formula but I wish for the text colour to change if a quotation needs to be sent but using conditional formation will not work. It will work in the rest of my worksheet but not in the column where this formula resides.

Can anyone help please?

=IF(A3="","No Contract",(IF(DATE(YEAR(A3),MONTH(A3),DAY(A3))<(TODAY()+90),"Send Quote",(DATE(YEAR(A3),MONTH(A3),DAY(A3)-90)))))

Thank you

Jo