spectraflame
Well-known Member
- Joined
- Dec 18, 2002
- Messages
- 829
- Office Version
- 365
- Platform
- Windows
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.
=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.