Hello

I have a coumn of data say A1 to A4 and I want to apply conditional formatting so that if the percentage of the A1 is greather than 25% then formate red.

The formula to calculate the percentage is

=SUM(A1/SUM(A1:A4))

I'm not sure how to apply this straight to the numerics as conditional formatting without a seperate % column which I don't want.

Thanks