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

#	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.0727

<tbody>
</tbody>

 

[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