excelproblem101
New Member
- Joined
- Jul 7, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- 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?
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?