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
So say for Example if Your formula is in Cell C3, and it results "Send Quote", you want "Send Quote" to be displayed in Red?
Is that right?
See the file attached
Cheers!
Deep Dave
Formulas for Condtional Formatting are written in a different way.
You specify only the condition where the formula is TRUE.
e.g.
a normal formula might say
=IF(A1="Red","Yes","No")
To format that cell via conditional formatting just specify the condition where it is TRUE, so
=(A1="Red")
and format as required.
Try
=IF(A3="","No Contract",(IF(DATE(YEAR(A3),MONTH(A3),DAY(A3))<(TODAY()+90),"Send Quote",(DATE(YEAR(A3),MONTH(A3),DAY(A3)-90)))))
=(AND(A3="No Contract",DATE(YEAR(A3),MONTH(A3),DAY(A3))<TODAY()+90)
format as required
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Im using the less than formatting =TODAY() in B3
Thank you
jo
Last edited by Jojojojo7; 07-23-2015 at 08:02 AM.
Thank you all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks