|I assume B8 is the result of a formula.|
2 things are missing from your question:
1 - What if B8 equals 79.99% or 99.99%, etc? You used the word between, but not the words equal to.
2 - What happens if it evaluates to 99.991% or 119.995?
Your criteria needs to be more specific.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.