Need Formula for conditional formatting

Status
Not open for further replies.

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 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.

1614616223946.png



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

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
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/20213. EDI Team Reviewing Changes
81920PQR IncorporatedMike DoeCollin12/15/202012/15/20201/13/20213. EDI Team Reviewing Changes
21222STU IncorporatedJanet DoeCollin2/3/20212/20/20212. Awaiting Vendor Response

Thank you in advance for any assistance you can provide!
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,934
Office Version
  1. 365
Platform
  1. Windows
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.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,808
Members
416,983
Latest member
LessThanAverageUser

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