cant drag the conditional formating rules formulas in column side, but i can do it in row wise

[bhavdip_mangukiya]

I have made conditional formating rules for my file. when i drag the formulas in row wise it works well in all the cell but if i drag in column side cell formula doesnt work properly

 

[awoohaw]

please use the xl2bb add in (link below) to post a mini worksheet of your data. Be sure to include Conditional Formatting rules (click the check box in the xl2bb ribbon).