Conditional Format: % of total

[AussieBec]

Hi Not sure if this can be done, I just can't work it out at this point.

Scenario:
A1: $10000
B1: $ 7500 (this is has a sum total)

How to I colour B1 when it reaches 25% of A1?
TIA
Bec

 

[Jacob Skaria]

Select B1.
Conditional formatting>Formula Is> enter below formula and select a color

(if equal)
=B1=A1*0.25
(if more than 25%)
=B1>A1*0.25

If this post helps click Yes

 

[AussieBec]

Thanks Jacob, it was easier than I thought. What if there was a different
figures in each cell. Would I need to set individual conditions or could I
use an if statement.
A1: 1000 b1:500
A2: 800 b2: 400
A3: 70 B3:60

 

[AussieBec]

Sorry, just worked it out. Remove absolute value.

 

[Jacob Skaria]

Happy to hear it worked.

If this post helps click Yes