Help highlighting rows based on cell contents

[Pharmacisticus]

Hi All,

I'm using Excel 2016 and need some help highlighting.
I've added a link to a picture of the worksheet I'm working on.
https://drive.google.com/open?id=121zcWYWY9W_6wqLiTiJaQCNdnAT2Jl2s

I want to highlight all rows that have the word "Complete" in column J
I've tried using conditional formatting but I can't get it to work, unfortunately, "complete" is a common word throughout the document so I keep getting rows highlighted that I don't want.

Any help would be greatly appreciated,

Cheers,

Josh

 

[Peter_SSs]

Select from cell A23 to the bottom right of your data and then apply the Conditional Formatting (formula) shown. Note the $ in front of the J.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
22
23										Complete
24		Doesn't matter if Complete appears in this column								Action
25
26										Action
27										Complete
28
CF complete

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A23	1. / Formula is =$J23="Complete"	Abc