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
|