Conditional formatting in Excel for blank values & dates

[David77]

Hello everybody,

To make this quick, i have the following setup.

I want to create a conditional formatting formula so whenever I have a value in column M (basically whenever the corresponding cell in column M is not blank), then my corresponding cell in column G should turn yellow.

How do I do this? Does anybody know?

Furthermore,

I have the following setup on the right side in my excel sheet:

Is it possible to create a conditional formatting so once the order date has been entered into Excel in column L and we have passed that date + 4 additional days, the designated cell value in column L gets highlighted with a red color?

So for example, if cell L1 has order date 16-10-2020 and we are on the 20-10-2020 now (4 days later) and the value in cell M1 has not been removed (so it still has the long number 8000166464/8000216970), then cell L1 will be highlighted with a red color until the value from cell M1 is removed and that cell goes blank.

I hope this makes sense!

I would really appreciate some help here, I cannot explain how much this would mean to me, it would truly make my day! Thank you so very much everybody

PLEASE let me know if you want more photos or information as well! I will be happy to respond ASAP!

Kind regards,
David

 

[Fluff]

Just add

O2<>"Yes"

as another argument to the AND

 

[David77]

Just add

O2<>"Yes"

as another argument to the AND

Amazing, it works!

Thank you so much Fluff!!!!

Have an amazing weekeend!

 

[Fluff]

Glad to help & thanks for the feedback.