Previous Topic Next Topic

100-1=99 then 99+1=100

Closed
Marian - Sep 4, 2015 at 05:28 PM
 Blocked Profile - Sep 4, 2015 at 06:57 PM
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




Related:

1 response

Answer 1 / 1
Blocked Profile
Sep 4, 2015 at 06:57 PM
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!