Applying conditional formating across multiple columns independently

[plat]

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

[BeachRock]

Copy Cells E2:E42. Highlight F2:F42, right click and paste formats. Highlight each column one at a time after and do the same.

[plat]

BeachRock,

Thank you very much for your reply but I am trying to find a solution that does not require me to repeat steps 80+ times as there are a large number of columns.

[FDibbins]

when you go into CF, change your CF range to =$B$2:$CI$41 this will aply your CF to the entire range, all in 1 go

[BeachRock]

Does this work?

[plat]

I do not want to apply the CF to all of the data together. I need it applied to each individual column independently. So the records in each column need to be considered their own data set for evaluation purposes.

[plat]

The final product should like the attached file.

[BeachRock]

Plat, please take a look at the attachment I put into my last post.

[BeachRock]

EDIT: You need to do the last colum in CJ by itself. All of the rest are within one CF rule though.

[plat]

BeachRock,

I did but unfortunately it's not what I am looking for. What I need is for the formating in each column to ignore any data that is not present in that particular column. In your example, all numbers in the entire range are taken into account and the CF is skewed as a result. I posted what the final product should look like a few posts back for comparison.

Thank you for taking the time to help!

[plat]

I did find the attached file here contains a macro that seems to do almost exactly what I am looking for. I am not very familiar with macros at all but maybe it can be modified to fit my needs?

[BeachRock]

Sorry, Plat.

[plat]

No worries! I appreciate you trying to help.

[BeachRock]

Hi Plat, I think you'll like this.

Open the attached file. Click the "Apply CF" button located in cell A1. Enjoy!

[plat]

Tony,

You're the man!!!!! Thank you so much this will save me an incredible amount of time.

[BeachRock]

Others have done the same for me in this forum many times so I'm happy to give back. It only took about an hour to do. Just recorded a macro for the first column and then added to the VB for all of the rest of the columns individually. I'm quite sure that someone with a better understanding of VB would be able to shorten the code down quite a bit but this works too.