Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
fonts for if...then statements
Hello, and thanks in advance for you help:
Without itterating through each cell, is there a way to format the cells in one column containing numerics , and leave the non-numerics as is? Selection.font.Italic = True Selection.font.Name = "Century Gothic" Thanks, Jimmy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
fonts for if...then statements
Hi Jimmy
Try this for column C Sub test() On Error Resume Next With Columns("C").SpecialCells(xlCellTypeConstants, xlNumbers) .Font.Italic = True .Font.Name = "Century Gothic" End With On Error GoTo 0 End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Jimmy" wrote in message ups.com... Hello, and thanks in advance for you help: Without itterating through each cell, is there a way to format the cells in one column containing numerics , and leave the non-numerics as is? Selection.font.Italic = True Selection.font.Name = "Century Gothic" Thanks, Jimmy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
fonts for if...then statements
Hello, Ron:
It works!!! Thanks a lot. Jimmy Ron de Bruin wrote: Hi Jimmy Try this for column C Sub test() On Error Resume Next With Columns("C").SpecialCells(xlCellTypeConstants, xlNumbers) .Font.Italic = True .Font.Name = "Century Gothic" End With On Error GoTo 0 End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Jimmy" wrote in message ups.com... Hello, and thanks in advance for you help: Without itterating through each cell, is there a way to format the cells in one column containing numerics , and leave the non-numerics as is? Selection.font.Italic = True Selection.font.Name = "Century Gothic" Thanks, Jimmy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
How can I lengthen the drop down Fonts list to show more fonts at | Excel Discussion (Misc queries) | |||
operator statements, shorting when reusing one of the statements? | Excel Programming | |||
fonts | Excel Discussion (Misc queries) | |||
Fonts | Excel Programming |