Conditional Formatting if Value is >=10% of B2

[spectraflame]

I have several cells that I would like to highlight if the value is 10% or greater of the value in B2. Is this the best approach?

=IF(B3/B2>=0.1,1,0)

If B2 = 50 and B3 = 5, there should be a highlight, but if the B3 value was changed to 4 the highlight goes away.

Any suggestions would be appreciated.

 

[Mike Blackman]

Hi,

Simply use;

=B3/B2>=0.1

There is no need for the if statement in CF.

 

[spectraflame]

Thanks for the help.