Conditional formatting

  • Thread starter Thread starter Ambarish.
  • Start date Start date
A

Ambarish.

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.
 
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)/A1>0.10
if x is 10%
 
hi,
assume previous cell is above and B2 and x%= 10%.

cell value is.......greater than........=B2*1.1........pick your fomat.

Regards
FSt1
 
Back
Top