Conditional formatting

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.
 
S

Sheeloo

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%
 
F

FSt1

hi,
assume previous cell is above and B2 and x%= 10%.

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

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top