Need Formula for conditional Formatting

[PaigeWarner]

I would like a formula for column F, that I can plug into conditional formatting where the lettering turns bold red when there is no date in column G, after it has passed a two week mark. So if we haven't received a response in two weeks, then it is in our face to follow up.

Here is the text in the table above, copy and pasted:

Vendor ID

Vendor Name

Merchant(s)

Team Member

First Processed

1.a. Emailed Vendor

2. Received Response

3.a. Merch Approval Requested

3.b. Merch EDI File Approved

4.a. SNOW Ticket Created

4.b. SNOW Ticket Number

5.a. Fixes Completed

Status

Notes

11121

GHI Incorporated

Mark Doe

Doris

2/5/2021

2/9/2021

2. Awaiting Vendor Response

12345

ABC Incorporated

John Doe

Collin

12/21/2020

12/21/2020

1/5/2021

1/6/2021

1/6/2021

N/A

RITM0128114

1/11/2021

6. Complete

67891

DEF Incorporated

Jane Doe

Doris

2/3/2021

2/10/2021

2. Awaiting Vendor Response

31415

JKL Incorporated

Jessica Doe

Doris

12/22/2020

12/22/2020

2. Awaiting Vendor Response

16171

MNO Incorporated

Larry Doe

Doris

12/22/2020

12/22/2020

1/13/2021

2. Awaiting Vendor Response

81920

PQR Incorporated

Mike Doe

Collin

12/15/2020

12/15/2020

1/13/2021

2. Awaiting Vendor Response

21222

STU Incorporated

Janet Doe

Collin

2/3/2021

2/10/2021

2. Awaiting Vendor Response

Thank you in advance for any assistance you can provide!

 

[Joe4]

Passed two weeks from which date?
The dates in column E?

 

[Joe4]

If it is column E, then try this CF formula for the entry in cell F2:

=AND(G2=0,TODAY()-E2>14)

 

[PaigeWarner]

So for example: If a cell in column G is blank and todays date is two weeks or more past the date in a cell in column F. I don't want the cell in column f to have bold red lettering if todays date is less than two weeks past.

Does that help?

 

[Joe4]

So for example: If a cell in column G is blank and todays date is two weeks or more past the date in a cell in column F. I don't want the cell in column f to have bold red lettering if todays date is less than two weeks past.

That doesn't seem to match what you showed in your examples.
All the dates in column F that you highlighted in red are less than two weeks old.

 

[PaigeWarner]

That doesn't seem to match what you showed in your examples.
All the dates in column F that you highlighted in red are less than two weeks old.

Sorry for the inconsistency Joe! I fixed the screen shot to match what I want:

Thank you so much for your help!

 

[Joe4]

So did you try what I suggested up in post 3?
Did that work for you?
I think it should do what you seem to want.

 

[PaigeWarner]

No it unfortunately didn't perform how I was hoping, The formula above was also for column E, I changed it to be for column F: =AND(G2=0,TODAY()-F2>14)
and it made cells F4 and F8 Bold red lettering instead of cell F5 and F2 should probably be red now as well. F4 and F8 should should not be red because that is less than two weeks old.

 

[Joe4]

OK, just a very slight adjustment.

1. Select cells F2:F8
2. Enter this Conditional Formatting formula:

=AND(G2=0,TODAY()-F2>14)

3. Select your red font formatting option

If you do this, it will match what you show you want up in post 6.

 

[PaigeWarner]

OK, just a very slight adjustment.

1. Select cells F2:F8
2. Enter this Conditional Formatting formula:

=AND(G2=0,TODAY()-F2>14)

3. Select your red font formatting option

If you do this, it will match what you show you want up in post 6.

Sorry Joe, never saw this. This works great, thank you so much!