Strange Conditional Formatting behaviour...

[Matty]

Hi,

I am using some VBA to apply Conditional Formatting to a Worksheet. The application of the rule works just fine.

However, while the Conditional Formatting formula is evaluating correctly, for whatever reason, the formatting isn't applied unless I manually go into the Conditional Formatting Rules Manager and hit 'Apply'.

Is there something I need to include in my code to ensure all formatting is refreshed and "applied"? Or is this a known bug?

I am using Excel 2007.

Thanks,

Matty

 

[Matty]

Hi barry,

Thanks for responding and confirming this as a known issue.

I haven't made the change yet, but I was going to go down the route you suggest by using a non-array formula. Hopefully this will fix the problem I'm seeing.

As always, I really appreciate the help of the knowledgeable members of this forum, so thanks again to you and Marcelo.

Matty