Fonts and colouring

[AnthonyWB]

Hello everyone.

I would like to use VBA code to automatically highlight every other row in say "light blue" and change the font of the worksheet, so that all numbers have commas and negative numbers are in red. However there are several columns which contain dates, and they need to remain unchanged - they are : V, W, X, and Z.

This needs to happen in the following worksheet which is created ( only poart of the code is shown)

Please Login or Register  to view this content.

I have tried the following but it does not work.

Please Login or Register  to view this content.

Any suggestions would be appreciated.

[romperstomper]

In what way does it not work? If it's just that it changes the date formats, then you can reset those columns afterwards:

Please Login or Register  to view this content.

for example.

[AnthonyWB]

Thanks I'll give that a go. But what about highlighting every other row?

[romperstomper]

You could use a template workbook for that and set it up using Conditional Formatting and then create a new workbook from the template each time rather than using the default blank workbook? (You could also set up the number formats in advance too)

[AnthonyWB]

Huh? I thought the best approach would be code?

[romperstomper]

Depends on your definition of 'best'.
If you use a template approach, then if you need to make changes to the formatting, you can just alter the template and leave the code alone. Up to you which you prefer though.

[AnthonyWB]

Actually I need the rows to be highlighted within this chunk of code. I need the first row to be a different colour than the other rows.

Please Login or Register  to view this content.

Trying to learn as much VBA as I can , so I would prefer code.