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

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


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