difference between cells

  1. P

    Conditional formatting - difference between cells

    Hi all, I have an excel sheet for recording the results from measurements made on round material. What I want is to have the conditional formatting so that if they have more than the allowed difference in a column they are highlighted red. Example: Allowed difference is 0.06 so the cells with...
    • Patto90
    • Thread
    • conditioanl formatting difference between cells highlight cells
    • Replies: 0
    • Forum: Excel Questions
  2. T

    Conditional formatting - difference between two cells

    Hi, In conditional formatting I'm trying to create a formula to say highlight if the difference between two cells is great than 5000 both ways. So, I've started =IF(A1="Standard", and this is the part where I need to say the current cell is a difference of 5000 compared to the previous cell...

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