100-1=99 then 99+1=100

Closed
Report
-
 Blocked Profile -
Hello,

Good day.

I want to ask something because i can't do this on my own.

i want to minus D18 - D21 = H20 (100-1=99)
H26 + H28 = H20 (99+1=100)

so if the amount or value is greater than the answer (H20) it will turn to red cell.

Thanks




1 reply


It is called conditional formatting. I have posted an example below:



Results in this:


I have said it once, I will say it again. IT!