Macro for conditional formatting using isna, match and indirect in the formula

[rmarroq]

I have configured conditional formatting to check valid entries in a dependant list. I used the solution provided by SHG at:

http://www.excelforum.com/excel-prog...ant-lists.html

Now I need to use a macro to activate and deactivate the conditional formatting due to performance issues.

When the formula for data validation includes the indirect funtion I got a compile error and the macro won't run.

Please Login or Register  to view this content.

[JBeaucaire]

I think you need some more quotes in there:

Please Login or Register  to view this content.

[JBeaucaire]

Post up that whole macro, it can be shortened up quite a bit.

[rmarroq]

Thanks, the double quotation marks worked fine.