Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight Cell
I want to highlight cells in the if statement if they exceed the
criteria (9). colorIndex doesn't seem to work with Cells. Is there another way to do this or another command I can use? thanks, Dim NumRows As Integer NumRows = Application.CountA(Columns(1)) MsgBox "Number of Rows " & NumRows Dim Row As Integer Row = 1 Do While Row <= NumRows If Len(Cells(Row, 1).Value) 9 Then Cells(Row, 1).ColorIndex = 3 End If Row = Row + 1 Loop Billy Rogers Dallas Texas Currently using Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
Highlight Cell Based Upon Referenced Cell Data | Excel Worksheet Functions | |||
click on one cell to find and highlight a related cell? | Excel Discussion (Misc queries) | |||
Highlight active cell and de-highlight previous cell | Excel Programming | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |