Applying conditional formating across multiple columns independently

It was suggested that I cross post my question from the formulas forum here. I was given a solution that saves quite a bit of time but a macro may be better?

After many hours of google'ing I come before you defeated.

The attached sheet is an array of various sales offices and their sales volume by day. What I would like to do is apply the conditional formating rules that I have already applied to the first few columns across the entire sheet. If I select the entire range and apply the conditional formating then it will rank the data in it's entirety. What I would like to do is apply the formating to each column, independently, without having to manually select the conditional formating rules 80+ times. I would like to be able to run this report daily but If I have to manually format each column it just isn't feasible.

I greatly appreciate any help or advice that can be provided.

Thank you!

http://www.excelforum.com/excel-form...html?p=2982932