100-1=99 then 99+1=100

Question

100-1=99 then 99+1=100

Closed

Report

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

100-1=99 then 99+1=100
192.168.100.1 not working - How-To - Router
Http //192.168.o.1.100 tp link ✓ - Forum - Network
1 11 111 pattern in c ✓ - Forum - Programming
192 l.168.0.1 - How-To - Network
Windows 8.1 online - Guide

1 reply

Ask a question

Blocked Profile · Answer 1 · 2015-09-04T18:57:02-0400

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!

100-1=99 then 99+1=100

1 reply

Your reply

Subscribe To Our Newsletter!