conditional formatting

[suresh kannah]

Hello Team

Need Conditional formatting compare 2 rows and highlight the data if the volume is more then 50 % .

The details are mentioned in the attachment.

Thanks In advance
Suresh

 

[Chihiro]

Highlight Data range in ColF.

New Rule->Use a Formula...

Formula is:
=($F2-$C2)/$C2>0.5

See attached.

 

[suresh kannah]

Hello Chihiro

Thanks A Lots,It works fine.

Thanks
Suresh