How to Format a Column???

[robertoduran]

How can i format a Column in order to show up negative numbers in a re
color, BUT using a MACRO..



for example:

Columns("G").Select



So i want to Format this "G"Column with the option to show negativ
numbers ex: if it is -100 will show (100) in red.

Thanks

 

[Jack Schitt]

I just did it using the Macro Recorder and then viewed the code:

Columns("G:G").Select
Selection.NumberFormat = "#,##0.00_); _
[Red](#,##0.00)"

Of course if doing it in a Macro there is no need to actually select the
column:

Columns("G:G").NumberFormat = "#,##0.00_); _
[Red](#,##0.00)"

 

[Frank Kabel]

Hi
one easy way:
- start recording a macro
- apply the custom format for column G
- use this recorded macro