LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formats, how to scroll and view all formats? Bill E Excel Worksheet Functions 0 May 12th 10 07:58 PM
Conditional formats- paste special formats? jcarney Excel Discussion (Misc queries) 1 November 1st 07 06:37 PM
paste conditional formats as formats leo Excel Discussion (Misc queries) 2 July 5th 07 10:06 AM
More than 3 conditional formats? Ltat42a Excel Discussion (Misc queries) 12 January 6th 06 11:26 AM
How do I add more Conditional Formats? Saint Excel Discussion (Misc queries) 2 April 26th 05 07:30 PM


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"