Font Formatting in Excel 2007

[M Kan]

You could just highlight the entire column and then select your formatting
options. As far as making everything upper case, I don't believe there is an
upper case formatting option, though you could use an UPPER formula on a
target cell.

 

[Misha]

Is there a way of font formatting an enitre column so that it will be in a
particular case, colour, font?
Thanks

 

[Rick Rothstein \(MVP - VB\)]

You can handle the color and font formats by selecting the column and
clicking Format/Cells from Excel's menu bar. Whatever selections you make
will apply to all the cells in the selected column. Forcing the case of the
text... that will require VB code. Here is how to make the text always be
upper case...

Right-click the worksheet you want this functionality on, select View Code
from the popup menu that appears and copy/paste the following into the code
window that appears...

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Whoops
Application.EnableEvents = False
If Not Intersect(Target, Range("A:B")) Is Nothing Then
Target.Value = UCase(Target.Value)
End If
Whoops:
Application.EnableEvents = True
End Sub

Change my Columns A and B reference in my Range("A:B") example to whatever
range of cells you want this functionality for.

Rick