Conditional Formatting help, highlighting a range between 2 Values?

Defski

New Member
Joined
Apr 25, 2018
Messages
16
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
67,955
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Defski

New Member
Joined
Apr 25, 2018
Messages
16
Book1
ABCDEFGHIJKLMNOPQRSTU
37042.653
436.136#DIV/0!
536.7131
6DateTimePV Zone 1Zone 1 Power (kW)PV Zone 2Zone 2 Power (kW)Pressure Zones Top / ColdFeeder (kg)Discharge (kg)Bed Height (in)Discharge SettingsDischarge Hold TimeNDIR/GCfeed ratefeed cumulativeDischarge rateProcessed Cumulative MassDiscrepancy
710/15/201912:0016418185062.0935.211.0870.285800.280.28
8Tues13:0016650184332.0938.511.0871.7366201.7362.016
914:0025757172362.2128.311.0877.64507.6459.661
1015:0024707151122.24309.5481.5391.539
1116:0022534166502.26328.0621.4863.025
1217:0021000176392.2234.46.4861.5764.601
1318:0019116177732.2136.75.1541.3325.933
1419:0017651183112.239.13.656731.4987.431
15Refill feed hopper and start discharge14.64207.431
1620:0017505183962.1837.913.4151071.2428.673
1721:0017529180662.239.111.92972151071.47110.144
1822:0018274179322.2139.710.42770151071.50211.646
1923:0018591176272.2140.18.97269151007/06/20191.45513.101
2010/16/20190:0018677174072.2240.37.4965.85369151061.47614.5775.85315.514-0.937
21Wed1:0019031172122.24395.97869.5151061.51816.095
222:0019177171512.22394.50668151061.47217.567
233:0019788171392.2639.23.00166151051.50519.072
244:0019434175782.2837.31.53570151205/04/20191.46620.538
25Refill feed hopper16.583020.538
265:0020300171752.2638.215.184751514/10/20196271.39921.937
276:0020220170732.283913.6998.12971151261.48523.4228.12923.643-0.221
287:0020447168092.2738.612.21272151061.48724.909
298:0020776166262.337.810.72473151061.48826.397
309:0020776167602.2637.79.2473151061.48427.881
3110:0020154174042.2735.97.78174151061.45929.34
3211:0019409179082.1837.46.2967315107371.48530.825
3312:0019458177252.2935.54.8127.05373151071.48432.3097.05330.6961.613
3413:0020007175872.19343.32475151071.48833.797
3514:0019446177982.1835.41.827315108401.50435.301
3616.83735.301
3715:001800189821800179812.1634.415.4274.5151008/09/20191.41736.718
3816:001800192751800177492.153513.93873151091.48238.2
3917:001800191891800175172.1633.712.4673151091.47839.678
4018:001800194701800173952.1533.810.9664.7273151009/08/20191.49441.1724.7235.4165.756
4119:001800194581800173952.1335.79.4850.7273151081.48142.6530.7236.1366.517
4220:001800192631800175662.1335.78.00274151281.48344.136
4321:001800194581800173582.12356.50472151281.49845.634
4422:001800195071800177492.1433.35.01273151291.49247.126
Wk42HS
 
Last edited by a moderator:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
67,955
Office Version
  1. 365
Platform
  1. Windows
Ok as U3 is greater than U5, you need to use
=and($R7<=$U$3,$R7>=$U$5)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
67,955
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,842
Messages
5,766,738
Members
425,376
Latest member
Bradleyckx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top