Dana DeLouis wrote...
As a side note, if you are increasing B1 by 'x', then the solution is to
solve for 'x' in the following equation:
0.95 = (B1+x)/((B1+x)+C1+D1)
....

A little algebra makes this simpler.

0.95 = 1 / [(B1+x) / (B1+x) + (C1+D1) / (B1+x)]
1 / 0.95 = 1 + (C1+D1) / (B1 + x)
1 / (1 / 0.95 - 1) = (B1 + x) / (C1 + D1)
(C1 + D1) / (1 / 0.95 - 1) = B1 + x

x = (C1 + D1) / (1 / 0.95 - 1) - B1