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