Conditionally format: Only if unique identifier and exceeds % of previous record

[JJ22]

So my problem pretty much is as the title states. I basically want to design a way to test if a patient's value for a parameter is abnormal compared to the rest of their values (previous record, adjacent records, average of all their records). I am not sure on the best method. For example, I might want to be able to flag blood pressures that are 25% greater or smaller than their other records as a way to systematically find which records I need to manually check for validation.

I want to conditionally format cells only if:
A) they have the same unique patient ID (PID) found in the first column
B) The value is 15% or greater than the previous record (or, even better, greater / lower than 15% of adjacent records values, or best, 15% against their average)

Each patient has a record per day of visit. I have sorted by newest date and then PID.

I have already tried this for SBP (you can see my example as green colored)
Format values where this formula is true: =J2/1.15>J3 and Applies to =$J:$J
While this works, for some cells (marked as good), when it is compares records from different people, or worse, blanks, it fails (WRONG).

What is the best way to go about solving this? I already have conditional formatting for extreme highs or lows a column, but nothing to figure out relative to their own records.

Any help would be appreciated. I'm just really tripped up on how to design a formula find "I want to highlight this cell based on this parameter, ONLY IF they have the same record."

PID_VAL	LNAME	FNAME	DOBKEY	AGE	SEX	INSURANCE	RELATIONSHIP	DATE	SBP	DBP	HT	WT	BMI		SBP
1	Richardson	Trent	4/17/1951	61.24	M	UCARE	Married	5/9/2011	152.00	67.00	69.75	289.70	41.90		152.00	GOOD
1	Richardson	Trent	4/17/1951	61.24	M	UCARE	Married	7/11/2011	125.00	58.00	69.75	279.50	40.40		125.00
1	Richardson	Trent	4/17/1951	61.24	M	UCARE	Married	10/14/2011	110.00	58.00	69.75	264.50	38.04		110.00
1	Richardson	Trent	4/17/1951	61.24	M	UCARE PMAP	Married	10/14/2011
2	Jackson	Bo	6/9/1981	31.08	M	HEALTHPARTNERS	Single	11/29/2010	147.00	92.00	75.00	482.80	60.40		147.00
3	Anderson	Gary	9/11/1947	64.84	M	MEDICA	Married	1/27/2012	141.00	83.00	69.02	235.80	34.81		141.00
3	Anderson	Gary	9/11/1947	64.84	M	MEDICA	Married	3/9/2012	141.00	80.00	69.02	237.00	34.98		141.00	Good
5	Wozniak	Steve	11/28/1979	32.61	F			3/25/2011	120.00	68.00	65.00	202.50	33.70		120.00
5	Wozniak	Steve	11/28/1979	32.61	F	MEDICA	Married	4/25/2011	111.00	59.00	65.00	201.40	33.50		111.00
6	Jobs	Steve	10/18/1978	33.72	F			2/1/2011	125.00	78.00	63.00	192.00	34.00		125.00
6	Jobs	Steve	10/18/1978	33.72	F			2/9/2011	152.00	67.00	69.75	289.70	41.90		152.00
6	Jobs	Steve	10/18/1978	33.72	F			2/11/2011	125.00	58.00	69.75	279.50	40.40		125.00
6	Jobs	Steve	10/18/1978	33.72	F			2/16/2011	110.00	58.00	69.75	264.50	38.04		110.00
6	Jobs	Steve	10/18/1978	33.72	F			3/1/2011	112.00	74.00	63.00	189.50	33.50		112.00
7	Gates	Bill	5/15/1984	28.14	M	MEDICA	Single	7/8/2011	128.00	70.00	73.50	258.30	33.60		128.00	WRONG
7	Gates	Bill	5/15/1984	28.14	M		Single	7/13/2011
8	Balmer	Steve	03/31/1959	53.28	M			9/17/2010	180.00	106.00	69.00	433.50	64.10		180.00	WRONG
8	Balmer	Steve	03/31/1959	53.28	M			9/29/2010
8	Balmer	Steve	03/31/1959	53.28	M			11/19/2010	144.00	90.00	69.00	402.90	59.50		144.00	WRONG
9	Peterson	Adrian	02/03/1976	36.43	F			7/6/2012
9	Peterson	Adrian	02/03/1976	36.43	F	UCARE PMAP	Married	7/25/2012
10	Stephano	Jeffry	5/31/1977	35.10	F	MEDICA	Married	2/9/2011	113.00	74.00		127.20			113.00
10	Stephano	Jeffry	5/31/1977	35.10	F	MEDICA	Married	5/18/2011	115.00	72.00		125.80			115.00
11	Flash	Forward	03/07/1967	45.35	M	MEDICA	Divorced	10/18/2010	124.00	76.00	69.50	199.50	29.00		124.00
12	Nestea	Iced	12/12/1948	63.59	F	METROPOLITAN HEALTH PLAN	Widowed	5/23/2012	111.00	56.00	60.00	167.70	32.75		111.00	WRONG
13	Montana	Tonya	5/5/1968	44.18	F	UCARE	Married	11/29/2011
13	Montana	Tonya	5/5/1968	44.18	F	UCARE	Married	12/21/2011
13	Montana	Tonya	5/5/1968	44.18	F	UCARE	Married	2/22/2012
13	Montana	Tonya	5/5/1968	44.18	F	UCARE	Married	3/16/2012	117.00	74.00	62.50	314.60	56.59		117.00	WRONG
13	Montana	Tonya	5/5/1968	44.18	F	UCARE	Married	4/26/2012
13	Montana	Tonya	5/5/1968	44.18	F	UCARE	Married	6/22/2012	150.00	96.00	63.00	315.40	55.88		150.00	WRONG
13	Montana	Tonya	5/5/1968	44.18	F			8/10/2012
14	Bolt	Usain	1/1/1981	31.51	F	MEDICA PMAP	Married	6/9/2010	107.00	71.00		199.70			107.00
14	Bolt	Usain	1/1/1981	31.51	F	MEDICA	Married	1/25/2012	116.00	71.00	60.00	207.00	40.43		116.00	WRONG

<tbody>
</tbody>