Applying conditional formating across multiple columns independently

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!

Hi plat,

This is what I would do... not completely painless, but would still be faster...

Highlight, column B, then double click Format Painter (Home tab, double click will "hold" this feature until you press ESC), then click on column C, then D, then E, etc. (one at a time) You can make it a little faster if, after doing this, say, 10 times, then you can Highlight the 10 columns, double click Format Painter and highlight the next 10 columns... the number of columns is important...

I'm sure there's a way to automate this using VBA (you might want to ask that thread).

Good luck,
Dennis

That saves me a ton of time! Thank you very much!!!