Conditional Formatting help, highlighting a range between 2 Values?

[Defski]

Hello,

I am hoping one of you Excel Masters can help me with my Conditional Formatting desirers.

What I would like to do is Highlight all the rows between 2 Values.

Currently I am using > Use a formula to determine which cells to format.

The formula I am using is =INDIRECT("R"& ROW())=$U$3 I then have it applying to =$A$7:$Z$1066.

This works great for part of what I would like to do, it takes the weight data I have in cell $U$3 and then highlights the part of whatever row that contains that data I need it to.

What I would like to do differently is use a second data point, the weight data I also have in cell $U$5 and then have it highlight all the rows between those two data points.

Is this something possible, it seems to me like it should be???

Thanks

 

[Fluff]

I am not sure if this is what you were expecting?

Not really, you are talking about formatting rows based on the values in column R using cells U3 & U5 as the criteria & you post a display of a single cell, namely S4 which has nothing to do with the conditional formatting.
Select A3:Z15 & post that data. please ensure that some of those rows need to be highlighted by CF & explain which ones.
Also do not select to show formulas.

 

[Defski]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
3																				70	42.653
4																				36.136	#DIV/0!
5																					36.7131
6	Date	Time	PV Zone 1	Zone 1 Power (kW)	PV Zone 2	Zone 2 Power (kW)	Pressure Zones Top / Cold		Feeder (kg)	Discharge (kg)	Bed Height (in)	Discharge Settings			Discharge Hold Time	NDIR/GC	feed rate	feed cumulative	Discharge rate	Processed Cumulative Mass	Discrepancy
7	10/15/2019	12:00		16418		18506	2.09	35.2	11.087	0.28	58						0		0.28	0.28
8	Tues	13:00		16650		18433	2.09	38.5	11.087	1.736	62						0		1.736	2.016
9		14:00		25757		17236	2.21	28.3	11.087	7.645							0		7.645	9.661
10		15:00		24707		15112	2.24	30	9.548								1.539	1.539
11		16:00		22534		16650	2.26	32	8.062								1.486	3.025
12		17:00		21000		17639	2.22	34.4	6.486								1.576	4.601
13		18:00		19116		17773	2.21	36.7	5.154								1.332	5.933
14		19:00		17651		18311	2.2	39.1	3.656		73						1.498	7.431
15	Refill feed hopper and start discharge								14.642								0	7.431
16		20:00		17505		18396	2.18	37.9	13.4			15	10	7			1.242	8.673
17		21:00		17529		18066	2.2	39.1	11.929		72	15	10	7			1.471	10.144
18		22:00		18274		17932	2.21	39.7	10.427		70	15	10	7			1.502	11.646
19		23:00		18591		17627	2.21	40.1	8.972		69	15	10	07/06/2019			1.455	13.101
20	10/16/2019	0:00		18677		17407	2.22	40.3	7.496	5.853	69	15	10	6			1.476	14.577	5.853	15.514	-0.937
21	Wed	1:00		19031		17212	2.24	39	5.978		69.5	15	10	6			1.518	16.095
22		2:00		19177		17151	2.22	39	4.506		68	15	10	6			1.472	17.567
23		3:00		19788		17139	2.26	39.2	3.001		66	15	10	5			1.505	19.072
24		4:00		19434		17578	2.28	37.3	1.535		70	15	12	05/04/2019			1.466	20.538
25	Refill feed hopper								16.583								0	20.538
26		5:00		20300		17175	2.26	38.2	15.184		75	15	14/10/2019	6	27		1.399	21.937
27		6:00		20220		17073	2.28	39	13.699	8.129	71	15	12	6			1.485	23.422	8.129	23.643	-0.221
28		7:00		20447		16809	2.27	38.6	12.212		72	15	10	6			1.487	24.909
29		8:00		20776		16626	2.3	37.8	10.724		73	15	10	6			1.488	26.397
30		9:00		20776		16760	2.26	37.7	9.24		73	15	10	6			1.484	27.881
31		10:00		20154		17404	2.27	35.9	7.781		74	15	10	6			1.459	29.34
32		11:00		19409		17908	2.18	37.4	6.296		73	15	10	7	37		1.485	30.825
33		12:00		19458		17725	2.29	35.5	4.812	7.053	73	15	10	7			1.484	32.309	7.053	30.696	1.613
34		13:00		20007		17587	2.19	34	3.324		75	15	10	7			1.488	33.797
35		14:00		19446		17798	2.18	35.4	1.82		73	15	10	8	40		1.504	35.301
36									16.837									35.301
37		15:00	1800	18982	1800	17981	2.16	34.4	15.42		74.5	15	10	08/09/2019			1.417	36.718
38		16:00	1800	19275	1800	17749	2.15	35	13.938		73	15	10	9			1.482	38.2
39		17:00	1800	19189	1800	17517	2.16	33.7	12.46		73	15	10	9			1.478	39.678
40		18:00	1800	19470	1800	17395	2.15	33.8	10.966	4.72	73	15	10	09/08/2019			1.494	41.172	4.72	35.416	5.756
41		19:00	1800	19458	1800	17395	2.13	35.7	9.485	0.72	73	15	10	8			1.481	42.653	0.72	36.136	6.517
42		20:00	1800	19263	1800	17566	2.13	35.7	8.002		74	15	12	8			1.483	44.136
43		21:00	1800	19458	1800	17358	2.12	35	6.504		72	15	12	8			1.498	45.634
44		22:00	1800	19507	1800	17749	2.14	33.3	5.012		73	15	12	9			1.492	47.126
Wk42HS

 

[Fluff]

Ok as U3 is greater than U5, you need to use
=and($R7<=$U$3,$R7>=$U$5)

 

[Defski]

Thank you sir You ROCK!!!

 

[Fluff]

You're welcome & thanks for the feedback