code for conditional formats

  • Thread starter Thread starter greg
  • Start date Start date
G

greg

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
 
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 (e-mail address removed)"greg"
 
Back
Top