100-1=99 then 99+1=100 Closed

Question

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




Configuration: Windows 7 / Chrome 45.0.2454.85

ac3mark · Answer

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!

100-1=99 then 99+1=100

1 response

Similar discussions

Subscribe To Our Newsletter!