I need help with the following:

1. Highlight the cell that contains the number closest to zero in the "-1.6" columns
2. Highlight the cell that contains the number closest to 1.600 in the "+/-%" columns
3. Highlight the cell that corresponds to the closest number to 1.600 in the "POST C276 +/-%" columns
4. Apply to all rows

image is attached to help visually bc this forum does not support tables


help.JPG

# SN TBD 10pF +8% -1.6 +6% -1.6 +4% -1.6 -5% -1.6 -9.2% -1.6 -13% -1.6 post c276 +8% post c276 +6% post c276 +4% post c276 -5% post c276 -9.2% post c276 -13%
1 1234 75 1.84221 1.98959 0.3896 1.95274 0.3527 1.91590 0.3159 1.75010 0.1501 1.67273 0.0727 1.60272 0.00272
2 1235 59 1.70000 1.83600 0.2360 1.80200 0.2020 1.76800 0.1680 1.61500 0.0150 1.54360 -0.0564 1.47900 -0.12100