# Conditional formatting in Excel for blank values & dates

#### David77

##### Board Regular
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

##### MrExcel MVP, Moderator
Excel Formula:
``O2<>"Yes"``
as another argument to the AND

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### David77

##### Board Regular
Excel Formula:
``O2<>"Yes"``
as another argument to the AND
Amazing, it works!

Thank you so much Fluff!!!!

Have an amazing weekeend!

#### Fluff

##### MrExcel MVP, Moderator
Glad to help & thanks for the feedback.

Replies
7
Views
72
Replies
16
Views
234
Replies
3
Views
148
Replies
3
Views
87
Replies
12
Views
557