Color only first three columns in excel

[Halley yenn]

Hello,

I have an excel sheet with 20k rows and 15 columns, my task is to color first three columns of this excel.
The color coding should be "Light orange" for column A and "light Green" for Column B and Column C.
I tried some vba code which is taking a lot of time to accomplish the task, can someone please guide me to do it in a quicker way using macro code??

KR
Halley

 

[Joe4]

Why do you need VBA?
You should just be able to select column A, and then choose the color that you want.
And then select columns B and C and choose the color that you want for them.

Is there something more to this that you are not telling us?

 

[Halley yenn]

Why do you need VBA?
You should just be able to select column A, and then choose the color that you want.
And then select columns B and C and choose the color that you want for them.

Is there something more to this that you are not telling us?

Hey,

Yes I need macro code for this.

Thanks

 

[Joe4]

If you turn on your Macro Recorder, and record yourself performing the steps I outlined in my previous post manually, you will have the exact VBA code that you need to do this (the Macro Recorder is a great tool for getting snippets of code like this).

If you need to make any "adjustments" to the code for any reason, post the code that you have recorded, along with an explanation of what adjustments need to be made.