Suppose you want to flag cells in Col A (Flag A2 by comparing with A1, A3
with A2...)
Select the range from A2 down to the last cell you want...
Choose FORMULA IS in Conditional Formatting and enter the formula as
=(A2-A1)/A10.10
if x is 10%

"Ambarish." wrote:

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.