Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formating data

ResolvedVersion 2010

Dhiresh has attended:
Excel Advanced course
Excel VBA Introduction course
Excel VBA Intermediate course

Formating data

Just started learning VBA so I have limited knowledge on the subject.

I am working on an Excel data file with multiple worksheets which I need formatted and colour coded based on each scenario. Details are added to the text file so:
1. how do I attached file to this forum?
2. can you help with the VBA code so that it carries out the steps and formats file.

RE: Formating data

Hi Dhiresh

Thank you for your question. I understand you have been in touch with Kevin and will be taking things forward with him. Do let us know if you have any further questions.

Kind regards,
Andrew

Wed 6 May 2015: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.