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))

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 01, 2021

Resguy Perhaps like this in C2 and copy down.

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

 

Resources