conditional formatting with specific range and color code

[mckeamic]

Hi All,
I think/hope this is the last help I need with the formulas (considering I've been working on this for a while now, lol)...
With the sample I have attached:
21J008 tab (page 1) (I highlighted it in green) the person will input in the weight under the columns D or J respectively.
It will auto populate below on page 2 Column F52:F90 (I highlighted it green) , there I have columns with percentages 11%-22% columns J-N respectively.

What I need the formula to do is:
With the inputted weight calculate which percentage its closer to and color the cell depending on if its 11% (one color), 15 & 18% (2nd color), 20% (3rd color), and 22% (4th color)
-Optional bonus if you can get the Column F,G,H,I 52:90 to highlight a neutral (5th color) if the number is greater than 0 in Column F52:F90.

Thank you for any help I can get. I am just so amazed how helpful and wonderful everyone is in this forum...
PS if I didn't do the upload mini sheet right, please let me know

Thank you

sample for forum help on weight chart.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N
23	DATE	DAY	WEIGHT	EXAM	HUMIDITY	ACTION	DATE	DAY	WEIGHT	EXAM	HUMIDITY	ACTION
24	1/14	1			56%	RCOM 1	2/4	22		7am = mvemnt
25	1/15	2	25.1 g	fert	56		2/5	23
26	1/16	3					2/6	24
27	1/17	4					2/7	25		7am = DD;mvemnt
28	1/18	5					2/8	26		7am = EP 1pm = mvemnt 4pm = mvemnt; progress
29	1/19	6	24.7 g	~ 1/4 cam	56	H down 40	2/9	27		7am = EP; mvemnt 4pm = EP; progression
30	1/20	7					2/10	28
31	1/21	8					2/11	29
32	1/22	9	24.3 g	~ 3/4 cam	40	H down 30	2/12	30
33	1/23	10					2/13	31
34	1/24	11					2/14	32
35	1/25	12					2/15	33
36	1/26	13	23.9 g	> 3/4 cam; dying?	30		2/16	34
37	1/27	14					2/17	35
38	1/28	15					2/18	36
39	1/29	16	23.5 g	CC; mvemnt	30	H down 25	2/19	37
40	1/30	17					2/20	38
41	1/31	18					2/21	39
42	2/1	19					2/22	40
43	2/2	20	23.0 g	mvemnt	25		2/23	41
44	2/3	21		7am = mvemnt; hatcher 4pm = mvemnt			2/24	42
45
46
47	Egg #	1			Egg Log #	21J008			Species	Nicobar Pigeon
48
49
50					ACTUAL WT.	DATE	DAY		11%	15%	18%	20%	22%
51	Date Laid		1/13/21
52	Date Found		1/13/21			1/13	0		25.30	25.30	25.30	25.30	25.30
53	Date Set		1/13/21		0.0 g	1/14	1		25.18	25.14	25.10	25.08	25.06
54	Date Set in Machine		1/13/21		25.1 g	1/15	2		25.06	24.97	24.91	24.86	24.82
55					0.0 g	1/16	3		24.94	24.81	24.71	24.65	24.58
56	Due date		2/5/21		0.0 g	1/17	4		24.82	24.65	24.52	24.43	24.35
57					0.0 g	1/18	5		24.70	24.49	24.33	24.22	24.11
58					24.7 g	1/19	6		24.58	24.33	24.14	24.01	23.88
59	min incubation period		23		0.0 g	1/20	7		24.47	24.17	23.95	23.80	23.65
60			-		0.0 g	1/21	8		24.35	24.01	23.76	23.59	23.43
61	max incubation period		26		24.3 g	1/22	9		24.23	23.85	23.57	23.39	23.20
62					0.0 g	1/23	10		24.12	23.70	23.39	23.18	22.98
63					0.0 g	1/24	11		24.00	23.54	23.21	22.98	22.76
64	NEED TO:			Ex. If wt is lower than normal, lower humidity (to reduce water loss).	0.0 g	1/25	12		23.89	23.39	23.02	22.78	22.54
65		Weight?			23.9 g	1/26	13		23.77	23.24	22.84	22.58	22.33
66					0.0 g	1/27	14		23.66	23.09	22.66	22.39	22.11
67					0.0 g	1/28	15		23.54	22.93	22.49	22.19	21.90
68	Then		Humidity		23.5 g	1/29	16		23.43	22.79	22.31	22.00	21.69
69					0.0 g	1/30	17		23.32	22.64	22.14	21.81	21.49
70				Ex. If wt is higher than normal, raise humidity (to increase water loss).	0.0 g	1/31	18		23.21	22.49	21.96	21.62	21.28
71		Weight?			0.0 g	2/1	19		23.10	22.34	21.79	21.43	21.08
72					23.0 g	2/2	20		22.99	22.20	21.62	21.25	20.88
73					0.0 g	2/3	21		22.88	22.05	21.45	21.06	20.68
74	Then		Humidity		0.0 g	2/4	22		22.77	21.91	21.28	20.88	20.48
75					0.0 g	2/5	23		22.66	21.77	21.12	20.70	20.28
76					0.0 g	2/6	24		22.55	21.62	20.95	20.52	20.09
77					0.0 g	2/7	25		22.44	21.48	20.79	20.34	19.90
78	Losing What %?				0.0 g	2/8	26		22.34	21.34	20.63	20.16	19.71
79	11%	15%	18%	Humidity Weight	0.0 g	2/9	27		22.23	21.20	20.46	19.99	19.52
80					0.0 g	2/10	28		22.12	21.06	20.30	19.81	19.33
81					0.0 g	2/11	29		22.02	20.93	20.14	19.64	19.15
21J008

Cell Formulas
Range	Formula
F24	F24	=DATA!U5
G24	G24	=DATA!S5
B24	B24	=H5+1
G53:G81,H25:H44,B25:B44	B25	=B24+1
H24	H24	=B44+1
C47	C47	=D3
G47	G47	=D4
K47	K47	=C5
G52	G52	=H3
J52	J52	=IF(DATA!O5=0,DATA!P5,DATA!O5)
K52	K52	=J52
L52	L52	=J52
M52	M52	=J52
N52	N52	=J52
J53:J62	J53	=J52-((J52*0.11)/D$59)
K53:K81	K53	=K52-((K52*0.15)/D$59)
L53:L81	L53	=L52-((L52*0.18)/D$59)
M53:M81	M53	=M52-((M52*0.2)/D$59)
N53:N81	N53	=N52-((N52*0.22)/D$59)
J63	J63	=J62-((J62*0.11)/D59)
J64	J64	=J63-((J63*0.11)/D59)
J65	J65	=J64-((J64*0.11)/D59)
J66	J66	=J65-((J65*0.11)/D59)
J67	J67	=J66-((J66*0.11)/D59)
J68	J68	=J67-((J67*0.11)/D59)
J69	J69	=J68-((J68*0.11)/D59)
J70	J70	=J69-((J69*0.11)/D59)
J71	J71	=J70-((J70*0.11)/D59)
J72	J72	=J71-((J71*0.11)/D59)
J73	J73	=J72-((J72*0.11)/D59)
J74	J74	=J73-((J73*0.11)/D59)
J75	J75	=J74-((J74*0.11)/D59)
J76	J76	=J75-((J75*0.11)/D59)
J77	J77	=J76-((J76*0.11)/D59)
J78	J78	=J77-((J77*0.11)/D59)
J79	J79	=J78-((J78*0.11)/D59)
J80	J80	=J79-((J79*0.11)/D59)
J81	J81	=J80-((J80*0.11)/D59)
F53:F73	F53	=D24
F74:F81	F74	=J24
D51:D54	D51	=H3
D56	D56	=H7
D59,D61	D59	=D13

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C24:C44	Expression	=AND(C24>=$D$13,C24<=$D$15)	text	NO
I24:I44	Expression	=AND(I24>=$D$13,I24<=$D$15)	text	NO