highlight cells closest to zero and 1.600 in columns, and apply to all rows

[joshsrai]

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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]#[/TD]
[TD]SN[/TD]
[TD]TBD[/TD]
[TD]10pF[/TD]
[TD]+8%[/TD]
[TD]-1.6[/TD]
[TD]+6%[/TD]
[TD]-1.6[/TD]
[TD]+4%[/TD]
[TD]-1.6[/TD]
[TD]-5%[/TD]
[TD]-1.6[/TD]
[TD]-9.2%[/TD]
[TD]-1.6[/TD]
[TD]-13%[/TD]
[TD]-1.6[/TD]
[TD]post c276 +8%[/TD]
[TD]post c276 +6%[/TD]
[TD]post c276 +4%[/TD]
[TD]post c276 -5%[/TD]
[TD]post c276 -9.2%[/TD]
[TD]post c276 -13%[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1234[/TD]
[TD]75[/TD]
[TD]1.84221[/TD]
[TD]1.98959[/TD]
[TD]0.3896[/TD]
[TD]1.95274[/TD]
[TD]0.3527[/TD]
[TD]1.91590[/TD]
[TD]0.3159[/TD]
[TD]1.75010[/TD]
[TD]0.1501[/TD]
[TD]1.67273[/TD]
[TD]0.0727[/TD]
[TD]1.60272[/TD]
[TD]0.0727[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

if you set up three conditional formats as a defined range between -0.1 to 0.1 would give you a visual target. if you have that in two cells then you can adjust without redoing the formulas