Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format Macro fails to set interior color - HELP!!!
Cell B3 has a data validation dropdown list.
When I change the selection it triggers a function on for that worksheet object: Private Sub Worksheet_Change(ByVal Target As Range) Select Case Target.Address Case Range("ModType").Address ValidateCoding End Select End Sub Where ModType is the range name for B3 The ValidateCoding routine lincludes: With Range("Coding") .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:=formatstring .FormatConditions(1).Interior.ColorIndex = 3 End With where the "Coding" range refers to cell B4. The formula part of the conditional formatting works fine, but I cannot seem to get the FormatConditions(1) to accept a color. If I run the same command directly as a subroutine it works fine??? HELP! Thanks in advance! joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to set cell interior color? | Excel Discussion (Misc queries) | |||
No Interior Color Macro | Excel Discussion (Misc queries) | |||
Interior Color Macro | Excel Programming | |||
Help!! Instead of Conditional Formatting, pull interior color from lookup | Excel Programming | |||
Conditional formatting & interior color | Excel Programming |