Formula for conditional format to highlight a row from column A to column Q

PaigeWarner

New Member
Joined
May 27, 2020
Messages
44
Office Version
  1. 365
Platform
  1. MacOS
I want to set conditional formatting with a formula for column N, when we mark something as Complete, that it highlights the whole row from column A to column N.

Here is an example:

1613599386728.png



Here is a Copy and Paste version:

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/20202. Awaiting Vendor Response
81920PQR IncorporatedMike DoeCollin12/15/202012/15/20202. Awaiting Vendor Response
21222STU IncorporatedJanet DoeCollin2/3/20212/10/20212. Awaiting Vendor Response


Thank you in advance for any assistance you can provide!
 

Some videos you may like

Excel Facts

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

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,575
Office Version
  1. 365
Platform
  1. MacOS
for 2007, 2010 , 2013 or 2016 excel version
Conditional Formatting

Highlight applicable range >>

Select the range you want to condition Say A2 to N1000


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=$N2="complete"


FormatÖ [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,575
Office Version
  1. 365
Platform
  1. MacOS
I see the word complete
is actually "6.complete" and in column M

is that correct ?
if so , see here

Book5
ABCDEFGHIJKLMN
1Vendor IDVendor NameMerchant(s)Team MemberFirst Processed1.a.23.a.3.b.4.a.4.b.5.a.StatusNotes
2EmailedReceivedMerch Approval RequestedMerch EDI File ApprovedSNOW Ticket CreatedSNOW Ticket NumberFixes Completed
3VendorResponse
411121GHI IncorporatedMark DoeDoris5/2/219/2/212. Awaiting Vendor Response
512345ABC IncorporatedJohn DoeCollin12/21/202012/21/20205/1/216/1/216/1/21N/ARITM012811411/1/216. Complete
667891DEF IncorporatedJane DoeDoris3/2/2110/2/212. Awaiting Vendor Response
731415JKL IncorporatedJessica DoeDoris12/22/202012/22/20202. Awaiting Vendor Response
816171MNO IncorporatedLarry DoeDoris12/22/202012/22/20202. Awaiting Vendor Response
981920PQR IncorporatedMike DoeCollin12/15/202012/15/20202. Awaiting Vendor Response
1021222STU IncorporatedJanet DoeCollin3/2/2110/2/212. Awaiting Vendor Response
11
12
13
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A1:N13Expression=$M1="6. complete"textNO
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,575
Office Version
  1. 365
Platform
  1. MacOS
you are welcome
 

Watch MrExcel Video

Forum statistics

Threads
1,127,098
Messages
5,622,694
Members
415,921
Latest member
ExcelGeek5038

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