A
Anton
I have two columns in a worksheet, one with date (Column J) and another with
status (Column K). I would like assistance with a formula that will enable
me to colour the cell in column J red if the date is more than 7 days ago and
Column K does not have the word "Complete" or "Quoted"
I have tried to use the following formaula which is not working correctly,
can somebody please assist?
=AND(K2<>OR(K2="Complete",K2="Quoted"),J2<=TODAY()-7)
Thank you in advance.
status (Column K). I would like assistance with a formula that will enable
me to colour the cell in column J red if the date is more than 7 days ago and
Column K does not have the word "Complete" or "Quoted"
I have tried to use the following formaula which is not working correctly,
can somebody please assist?
=AND(K2<>OR(K2="Complete",K2="Quoted"),J2<=TODAY()-7)
Thank you in advance.