Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
skipping text formats
Hi:
The following program goes through a column of data and highlights vlues over a certain constant. The only problem is that it also highlights the cells with text also? Can anybody show me how to highlight numbers only? Thanks in advance for your help! Sub ChangeCellBasedonValue() Dim limit As Integer limit = Range("k1").Value For Each c In ActiveSheet.Range("e:e").Cells If c.Value limit Then With c.Font .Bold = False .Italic = False .ColorIndex = 3 End With With c.Interior .ColorIndex = 14 End With End If Next c MsgBox "All done!" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
Skipping Text Entries | Charts and Charting in Excel | |||
Date Formats in Text Box | Excel Discussion (Misc queries) | |||
Skipping Import Text File dialog in a Macro | Excel Discussion (Misc queries) | |||
Can you retain different text formats when merging text? | Excel Discussion (Misc queries) |