Forum Discussion

Resguy's avatar
Resguy
Copper Contributor
Jul 01, 2021
Solved

If function and conditional formatting

Hi,   I'm trying to set up a formula where by if the sent date was more than 5 days ago and we have not received anything back yet, column B turns red. If its less than 5 days since it was sent, Co...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jul 01, 2021

    Resguy 

    Change the formula to

     

    =IF(E2=Sheet3!$F$3,2,IF(AND(A2<=TODAY()-5,B2=""),1,0))

HansVogelaar's avatar
HansVogelaar
MVP
Jul 01, 2021

Resguy 

Change the formula to

 

=IF(E2=Sheet3!$F$3,2,IF(AND(A2<=TODAY()-5,B2=""),1,0))

  • Resguy's avatar
    Resguy
    Copper Contributor
    Jul 01, 2021
    This has worked, Thank you for your help.

Resources