Conditional Format: % of total
 

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

Conditional Format: % of total
 

Select B1.
Conditional formattingFormula Is enter below formula and select a color

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

If this post helps click Yes
---------------
Jacob Skaria


"AussieBec" wrote:

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

Conditional Format: % of total
 

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

"Jacob Skaria" wrote:

Select B1.
Conditional formattingFormula Is enter below formula and select a color

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

If this post helps click Yes
---------------
Jacob Skaria


"AussieBec" wrote:

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

Conditional Format: % of total
 

Sorry, just worked it out. Remove absolute value.

"AussieBec" wrote:

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

"Jacob Skaria" wrote:

Select B1.
Conditional formattingFormula Is enter below formula and select a color

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

If this post helps click Yes
---------------
Jacob Skaria


"AussieBec" wrote:

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

Conditional Format: % of total
 

Happy to hear it worked.

If this post helps click Yes
---------------
Jacob Skaria


"AussieBec" wrote:

Sorry, just worked it out. Remove absolute value.

"AussieBec" wrote:

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

"Jacob Skaria" wrote:

Select B1.
Conditional formattingFormula Is enter below formula and select a color

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

If this post helps click Yes
---------------
Jacob Skaria


"AussieBec" wrote:

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