Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with the following code...from EntireRow to set width
I have this code to format the entire row a certain color depending on
the text in Column "I". However, I really just want it to go from column "A" to column "J". What would I substitute for ".EntireRow"? '------------------------------------------ Sub ConditionalFormatter() [I2].Activate With Range([I2], [I65536].End(xlUp)).EntireRow .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:="= $I2=""N""" .FormatConditions(1).Interior.ColorIndex = 10 .FormatConditions(1).Font.ColorIndex = 2 .FormatConditions.Add Type:=xlExpression, Formula1:="= $I2=""X""" .FormatConditions(2).Interior.ColorIndex = 19 .FormatConditions(2).Font.ColorIndex = 1 End With End Sub '------------------------------------------ Thanks, Todd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change every 3 columns width with code | Excel Programming | |||
Dropdown list width changing code | Excel Worksheet Functions | |||
ActiveWindow.VisibleRange.Width - Is this the correct code | Excel Programming | |||
adding code to shrink columns to reasonable width | Excel Programming | |||
Using Code to Adjust Specific Column Width | Excel Programming |