Return multiple values within value range and color cells.

S

snorriba

New Member
Joined
Oct 30, 2018
Messages
1
[TABLE="width: 25"]
<tbody>[TR]
[TD]

<tbody>
[TD="class: xl65"]198.87[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]768.0E-9[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="class: xl65, width: 93"]25.32[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]9.4E-5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]128879.20[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]300[/TD]

</tbody>
[/TD]
[/TR]
[TR]
[TD]

<tbody>
[TD="class: xl65"]146.11[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]967.8E-9[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="class: xl65, width: 93"]18.60[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]9.4E-5[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="class: xl65, width: 97"]69565.78[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]350[/TD]
[/TR]
[TR]
[TD]

<tbody>
[TD="class: xl65"]111.86[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]1.2E-6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]14.24[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]9.4E-5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="class: xl65, width: 97"]40778.19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]88.39[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]1.4E-6[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]11.25[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]9.4E-5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="class: xl65, width: 97"]25457.62[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]450[/TD]
[/TR]
[TR]
[TD]

<tbody>
[TD="class: xl65"]71.59[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]1.7E-6[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]9.12[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]9.4E-5[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]16702.74[/TD]

</tbody>
[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]59.17[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]1.9E-6[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="class: xl65, width: 93"]7.53[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]9.4E-5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="class: xl65, width: 97"]11408.20[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]550[/TD]
[/TR]
[TR]
[TD]

<tbody>
[TD="class: xl65"]49.72[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]2.2E-6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]6.33[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]9.4E-5[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]8054.95[/TD]

</tbody>
[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]42.36[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]2.4E-6[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]5.39[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]9.4E-5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="class: xl65, width: 60"]356.7[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]5848.10[/TD]

</tbody>
[/TD]
[TD]650[/TD]
[/TR]
[TR]
[TD]

<tbody>
[TD="class: xl65"]36.53[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]2.7E-6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]4.65[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]9.4E-5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="class: xl65, width: 97"]4347.86[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]700[/TD]
[/TR]
[TR]
[TD]

<tbody>
[TD="class: xl65"]31.82[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]3.0E-6[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]4.05[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]9.4E-5[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="class: xl65, width: 60"]356.7[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="class: xl65, width: 97"]3299.31[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]750[/TD]
[/TR]
[TR]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]27.97[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]3.3E-6[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]3.56[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]9.4E-5[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="class: xl65, width: 97"]2548.64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]800[/TD]
[/TR]
[TR]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]24.77[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]3.7E-6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="class: xl65, width: 93"]3.15[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]9.4E-5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="class: xl65, width: 60"]356.7[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]1999.83[/TD]

</tbody>
[/TD]
[TD]850[/TD]
[/TR]
[TR]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD]22.10[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]4.0E-6[/TD]
[TD]2.81[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]9.4E-5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD]1591.10[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]19.83[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]4.3E-6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="class: xl65, width: 93"]2.53[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]9.4E-5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="class: xl65, width: 60"]356.7[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="class: xl65, width: 97"]1281.66[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]950[/TD]
[/TR]
[TR]
[TD]

<tbody>
[TD="class: xl65"]17.90[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]4.7E-6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="class: xl65, width: 93"]2.28[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]9.4E-5[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]1043.92[/TD]

</tbody>
[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]

<tbody>
[TD="class: xl65"]10.59[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]6.9E-6[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="class: xl65, width: 93"]1.35[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]9.4E-5[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="class: xl65, width: 60"]356.7[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="class: xl65, width: 97"]365.51[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1300[/TD]
[/TR]
[TR]
[TD]

<tbody>
[TD="class: xl65"]6.99[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]9.5E-6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]0.89[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]9.4E-5[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="class: xl65, width: 60"]356.7[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="class: xl65, width: 97"]159.29[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1600[/TD]
[/TR]
[TR]
[TD]

<tbody>
[TD="class: xl65"]4.47[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]13.2E-6[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD="class: xl65, width: 93"]0.57[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<tbody>
[TD="class: xl65"]9.4E-5[/TD]

</tbody>
[/TD]
[TD]

<tbody>
[TD="class: xl65"]356.7[/TD]

</tbody>
[/TD]
[TD][TABLE="width: 97"]
<tbody>[TR]
[TD="class: xl65, width: 97"]65.25[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2000[/TD]
[/TR]
</tbody>[/TABLE]

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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Possible Cyclones Diameter[/TD]
[/TR]
[TR]
[TD]850[/TD]
[/TR]
[TR]
[TD]900[/TD]
[/TR]
[TR]
[TD]950[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[/TR]
</tbody>[/TABLE]

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

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
You must log in or register to reply here.

Similar threads

G
  • Question Question
Getting a Match Function to Lookup a Numeric Value Within a Range of Table Headers
Replies
5
Views
1K
DanteAmor
DanteAmor
F
  • Question Question
Return Colum headers based on positive and negative cell value
Replies
8
Views
3K
AhoyNC
A
C
  • Question Question
Find first match from one range in another range and return related value
Replies
8
Views
1K
Fluff
Fluff
montecarlo2012
  • Question Question
["VBA"] >return a value from an “ADJACENT” formatting color cell
2 3
Replies
20
Views
1K
Fluff
Fluff
C
  • Locked
  • Question Question
I need modifications in my macro to copy the cell values containing a particular substring and the values against those cells in the third right colum
Replies
1
Views
569
Fluff
Fluff

Forum statistics

Threads
1,224,819
Messages
6,181,153
Members
453,021
Latest member
Justyna P

Share this page

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