Conditional formula based on difference of two other cells

excelproblem101

New Member
Joined
Jul 7, 2022
Messages
4
Office Version
  1. 365
Platform
  1. Windows
i have a sheet with values in Column D and E

Now, they enter values in E45 and E36
Afterwards, they enter a value on D48 (They should calulate the difference of E45 and E36
The conditional formula should make the cell D56 red if they value they enter is not equal to the difference of E45 and E36
I have the following formula: =$D$48<>$E$45-$E$36

Now the format is only working if I have a formula in D48 with =E45-E36
But they need to enter the value.
I tried to change the formula to =D48<>ABS(E45-E36)
But still no luck.

Please assist?
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
In what way is that formula not working?
 
Upvote 0
The conditional format is not working.
So it is not making the cell fill color red if the difference of E45 and E36 is not entered in cell D48.
 
Upvote 0
What are the values in those 3 cells when it doesn't work?
 
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,151
Members
453,021
Latest member
Justyna P

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