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

[PaigeWarner]

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:

Here is a Copy and Paste version:

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

2. Awaiting Vendor Response

81920

PQR Incorporated

Mike Doe

Collin

12/15/2020

12/15/2020

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!

 

[etaf]

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]

I see the word complete
is actually "6.complete" and in column M

is that correct ?
if so , see here

Book5
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Vendor ID	Vendor Name	Merchant(s)	Team Member	First Processed	1.a.	2	3.a.	3.b.	4.a.	4.b.	5.a.	Status	Notes
2						Emailed	Received	Merch Approval Requested	Merch EDI File Approved	SNOW Ticket Created	SNOW Ticket Number	Fixes Completed
3						Vendor	Response
4	11121	GHI Incorporated	Mark Doe	Doris	5/2/21	9/2/21							2. Awaiting Vendor Response
5	12345	ABC Incorporated	John Doe	Collin	12/21/2020	12/21/2020	5/1/21	6/1/21	6/1/21	N/A	RITM0128114	11/1/21	6. Complete
6	67891	DEF Incorporated	Jane Doe	Doris	3/2/21	10/2/21							2. Awaiting Vendor Response
7	31415	JKL Incorporated	Jessica Doe	Doris	12/22/2020	12/22/2020							2. Awaiting Vendor Response
8	16171	MNO Incorporated	Larry Doe	Doris	12/22/2020	12/22/2020							2. Awaiting Vendor Response
9	81920	PQR Incorporated	Mike Doe	Collin	12/15/2020	12/15/2020							2. Awaiting Vendor Response
10	21222	STU Incorporated	Janet Doe	Collin	3/2/21	10/2/21							2. Awaiting Vendor Response
11
12
13
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:N13	Expression	=$M1="6. complete"	text	NO

 

[PaigeWarner]

Thank you, that worked perfectly!

 

[etaf]

you are welcome