I wish to set-up a conditional formatting where-in if the value of a cell in
comparison to the previous cell goes above x% , it should get flagged.. and
this should be continious.

How do I go about doing that.