0

I need a formula that will provide this conditional formatting in Google Sheets. Please help.

Column H = Date the request was sent
Column I = Date the response was received

I need to ensure I have a response within 2 days of sending the request. So I want column I to update to Yellow 1 day after the request was sent (Column H) & Red 2 days or more after the request was sent (Column H) so I know I need to escalate for a response. What formula could I use in Conditional Format rules?

1

1 Answer 1

1

you'll need two conditional formatting rules:

  1. for red

    =and(today()>=H2+2,H2<>"",I2="")

  2. for yellow

    =and(today()=H2+1,I2="")

test sheet

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.