Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
code for conditional formats
Hello,
I am seeing some wierd things. I am creating VBA code. where I make 1 pass. and add in a bunch of generic conditional formats. then I run a second pass and put in the business logic. So I modify the conditional formats that i created before. But it does not seem to really get updated. If i pause the code. and open the conditional formats dialog. then run the code. it seems to work fine. has anyone seen this bug? my modify code is like this: objFormatConditions.Modify xlExpression, Formula1:="=UPPER(" & strTempString & ") < ""X"" " thanks for any help |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
code for conditional formats
Maybe? this from vba help
Modify Method (FormatCondition Object) Modifies an existing conditional format. expression.Modify(Type, Operator, Formula1, Formula2) expression Required. An expression that returns a FormatCondition object. Type Required XlFormatCondition. Specifies whether the conditional format is based on a cell value or an expression. XlFormatCondition can be one of these XlFormatCondition constants. xlCellValue xlExpression Operator Optional XlFormatConditionOperator. The conditional format operator. XlFormatConditionOperator can be one of these XlFormatConditionOperator constants. xlBetween xlEqual xlGreater xlGreaterEqual xlLess xlLessEqual xlNotBetween xlNotEqual If Type, is xlExpression, the Operator argument is ignored. Formula1 Optional Variant. The value or expression associated with the conditional format. Can be a constant value, a string value, a cell reference, or a formula. Formula2 Optional Variant. The value or expression associated with the conditional format. Can be a constant value, a string value, a cell reference, or a formula.. Example This example modifies an existing conditional format for cells E1:E10. Worksheets(1).Range("e1:e10").FormatConditions(1) _ .Modify xlCellValue, xlLess, "=$a$1" -- Don GuillettSalesAid "greg" wrote in message ... Hello, I am seeing some wierd things. I am creating VBA code. where I make 1 pass. and add in a bunch of generic conditional formats. then I run a second pass and put in the business logic. So I modify the conditional formats that i created before. But it does not seem to really get updated. If i pause the code. and open the conditional formats dialog. then run the code. it seems to work fine. has anyone seen this bug? my modify code is like this: objFormatConditions.Modify xlExpression, Formula1:="=UPPER(" & strTempString & ") < ""X"" " thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formats, how to scroll and view all formats? | Excel Worksheet Functions | |||
Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
paste conditional formats as formats | Excel Discussion (Misc queries) | |||
More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
How do I add more Conditional Formats? | Excel Discussion (Misc queries) |