Return multiple values within value range and color cells.

snorriba

New Member
Joined
Oct 30, 2018
Messages
1
198.87

<tbody>
</tbody>
768.0E-9

<tbody>
</tbody>
25.32

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
128879.20

<tbody>
</tbody>
300

<tbody>
</tbody>
146.11

<tbody>
</tbody>
967.8E-9

<tbody>
</tbody>
18.60

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
69565.78

<tbody>
</tbody>
350
111.86

<tbody>
</tbody>
1.2E-6

<tbody>
</tbody>
14.24

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
40778.19

<tbody>
</tbody>
400
88.39

<tbody>
</tbody>
1.4E-6

<tbody>
</tbody>
11.25

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
25457.62

<tbody>
</tbody>
450
71.59

<tbody>
</tbody>
1.7E-6

<tbody>
</tbody>
9.12

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
16702.74

<tbody>
</tbody>
500
59.17

<tbody>
</tbody>
1.9E-6

<tbody>
</tbody>
7.53

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
11408.20

<tbody>
</tbody>
550
49.72

<tbody>
</tbody>
2.2E-6

<tbody>
</tbody>
6.33

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
8054.95

<tbody>
</tbody>
600
42.36

<tbody>
</tbody>
2.4E-6

<tbody>
</tbody>
5.39

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
5848.10

<tbody>
</tbody>
650
36.53

<tbody>
</tbody>
2.7E-6

<tbody>
</tbody>
4.65

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
4347.86

<tbody>
</tbody>
700
31.82

<tbody>
</tbody>
3.0E-6

<tbody>
</tbody>
4.05

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
3299.31

<tbody>
</tbody>
750
27.97

<tbody>
</tbody>
3.3E-6

<tbody>
</tbody>
3.56

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
2548.64

<tbody>
</tbody>
800
24.77

<tbody>
</tbody>
3.7E-6

<tbody>
</tbody>
3.15

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
1999.83

<tbody>
</tbody>
850
22.10

<tbody>
</tbody>
4.0E-62.81
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
1591.10900
19.83

<tbody>
</tbody>
4.3E-6

<tbody>
</tbody>
2.53

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
1281.66

<tbody>
</tbody>
950
17.90

<tbody>
</tbody>
4.7E-6

<tbody>
</tbody>
2.28

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
1043.92

<tbody>
</tbody>
1000
10.59

<tbody>
</tbody>
6.9E-6

<tbody>
</tbody>
1.35

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
365.51

<tbody>
</tbody>
1300
6.99

<tbody>
</tbody>
9.5E-6

<tbody>
</tbody>
0.89

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
159.29

<tbody>
</tbody>
1600
4.47

<tbody>
</tbody>
13.2E-6

<tbody>
</tbody>
0.57

<tbody>
</tbody>
9.4E-5

<tbody>
</tbody>
356.7

<tbody>
</tbody>
65.25

<tbody>
</tbody>
2000

<tbody>
</tbody>

Hello.
I am looking for a way to find values in table within a value range.
I got this table

https://imgur.com/a/ipRx16R

I am trying to color all the rows that have pressure drop (colum H) between 500 and 2000. I have only managed to color one row that comes next to a single value, in this case 1500.
Also i was wondering of there is a chance to return the values of colum I in the colored rows to another table. So for the instance in the picture it would look like this.

Possible Cyclones Diameter
850
900
950
1000

<tbody>
</tbody>

The table on the top of this post has the same values as the picture in the link.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,215,331
Messages
6,124,311
Members
449,152
Latest member
PressEscape

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
Back
Top