conditional format

[suresh kannah]

Highlight cells where percentage of volume increased or decreases by 50%,
Attached is the excel sheet with sample data and highlighted.

Need formula for the same.

Need help
Suresh

 

[Awesome Wally]

Try using this formula in your conditional format rule:

=OR(F2>C2+(C2*50%),C2-(C2*50%)>F2)

See attached. I used teal to differentiate from original yellow highlight.

 

[suresh kannah]

HI

Thanks,It works fine

Regards
Suresh