Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have code that loops through all rows, checks the value in a specific cell
and based on that value sets the fill color for that cell. I want to set the fill color for the entire row. Ideally, the code would only set the fill color for the columns I am using (columns A - M), but setting the fill color for the entire row (beyond column N) would be better than what I have now. Dim r As Range Dim n As Integer ' Format_Status_Colors Set r = Range("K1", Range("K65536").End(xlUp)) For n = 2 To r.Rows.Count If r.Cells(n, 1) = "" Then ' Do nothing ElseIf r.Cells(n, 1) = "Needs to be Validated" Then r.Cells(n, 1).Select With Selection.Interior .ColorIndex = 37 .Pattern = xlSolid End With ElseIf r.Cells(n, 1) = "Validated" Then r.Cells(n, 1).Select With Selection.Interior .ColorIndex = 35 .Pattern = xlSolid End With End If Next n Can anyone help me set the fill color for the row I am on, not just the cell? Thank you, Judy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
End Select without Select Case, Block If without End If errors | Excel Programming | |||
Select other workbook to select data in a macro. | Excel Programming |