0

I'm trying to make a spread sheet to track open purchase orders. One PO per row. One column has the order date in it, and the next column has the receive date for the order. I'd like the cell with the order date to highlight red if the date in it is more than a week old, and there is nothing in the cell for the receive date. I'm new to this, so I scoured forums for a formula that would work, but it always says invalid formula. This is one I copy and pasted from a Q&A site:

=AND(TODAY()-7,(ISBLANK()C2:C))

It's invalid, but I don't know enough about this stuff to know why.

0

You mentioned:

Highlight order date if it is more than a week old, and there is nothing in the cell for the receive date

Please use the following rule:

=AND(G2<>"",G2<TODAY()-7,ISBLANK(H2))

enter image description here

1
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. – marikamitsos Jan 6 at 19:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.