100-1=99 then 99+1=100

 Blocked Profile -

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.


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!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!