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 after it has passed a two week mark (from the date in column F). So if we haven't received a response in two weeks, then it is in our face to follow up. Also, once another date has been put into the field next to it in Column G- I want the bold red lettering to return to normal font and color.

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. (cell F7 as an example of being less than two weeks) but I do want the the cell in column F to have bold red lettering if todays date is more than two weeks past (Cells F2, F3 and F4 as an example of being more than two weeks).

Cells F5 and F6 are an example of the bold red lettering going back to normal when something is plugged into the cellsG5 and G6 next to them.

Here is a copy and paste of the text in the chart above:

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

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

3. EDI Team Reviewing Changes

81920

PQR Incorporated

Mike Doe

Collin

12/15/2020

12/15/2020

1/13/2021

3. EDI Team Reviewing Changes

21222

STU Incorporated

Janet Doe

Collin

2/3/2021

2/20/2021

2. Awaiting Vendor Response

Thank you in advance for any assistance you can provide!

 

[Joe4]

Duplicate to: Need Formula for conditional Formatting

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.
I had replied to it last week with an update that you never responded to.