highlight closest value

  1. J

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

    i need help with the following: Highlight the cell that contains the number closest to zero in the "-1.6" columns Highlight the cell that contains the number closest to 1.600 in the "+/-%" columns Highlight the cell that corresponds to the closest number to 1.600 in the "POST C276 +/-%" columns...
  2. S

    Conditional Formatting - Highlight the closest value to a number

    Hello everyone! I need your help for the following example situation. I have a column of values, lets say from A1 to A5 (numbers with 3 digits after coma) and the cell B1 with the value 2.255: A1 - 0.856 A2 - 1.245 A3 - 1.455 A4 - 2.250 A5 - 2.260 I want to highlight the cell from A1 to A5...
  3. G

    Conditional Formatting - Highlight closest value in excel

    I have a number in cell J10 and need to highlight the closest number to it from the following cells:N10, R10, V10, Z10, AD10, AH10, AL10, AP10. I have found help from sites that show things in columns but I need to know how to do it in rows instead. I have looked for a couple of hours and am...

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