Need Formula for conditional Formatting

PaigeWarner

New Member
Joined
May 27, 2020
Messages
44
Office Version
  1. 365
Platform
  1. MacOS
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.

1613758106011.png


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

Vendor IDVendor NameMerchant(s)Team MemberFirst Processed1.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
StatusNotes
11121GHI IncorporatedMark DoeDoris2/5/20212/9/20212. Awaiting Vendor Response
12345ABC IncorporatedJohn DoeCollin12/21/202012/21/20201/5/20211/6/20211/6/2021N/ARITM01281141/11/20216. Complete
67891DEF IncorporatedJane DoeDoris2/3/20212/10/20212. Awaiting Vendor Response
31415JKL IncorporatedJessica DoeDoris12/22/202012/22/20202. Awaiting Vendor Response
16171MNO IncorporatedLarry DoeDoris12/22/202012/22/20201/13/20212. Awaiting Vendor Response
81920PQR IncorporatedMike DoeCollin12/15/202012/15/20201/13/20212. Awaiting Vendor Response
21222STU IncorporatedJanet DoeCollin2/3/20212/10/20212. Awaiting Vendor Response

Thank you in advance for any assistance you can provide!
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,512
Office Version
  1. 365
Platform
  1. Windows
You are welcome.
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,127,098
Messages
5,622,674
Members
415,920
Latest member
ExcelNoob28

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top