How to Format a Column???

R

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
 
F

Frank Kabel

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