View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
greg greg is offline
external usenet poster
 
Posts: 59
Default 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