Looking for a formula to change RYG status if multiple cell dates are blank?


Looking for a formula that says if the "Drawings Received" "WPS Received" and " ITP Received" column is blank 3 days after the date stated in the "Quoted" columns then turn the "Preconstruction Status" column to Yellow. And would also like it to turn Red if its 7 days after the date in the Quoted column.


  • James Keuning
    James Keuning ✭✭✭✭✭

    To be clear: the condition is if all three are blank, or if any of the three are blank?

    The way you can do this is to create two helper columns, one for Quoted+3 and one for Quoted+7. Then you will use another helper column and the TODAY function to figure out if TODAY is greater than Quoted+3 and if it is greater than Quoted+7, and then if it is, then look to see of those received fields are blank, and you use either OR or AND to do that, depending on what you are actually trying to do. From there you use conditional formatting based on the result.