Please help with VBA - Conditional Formatting from 2 columns

Thank you for reading my post. I have a spreadsheet that contains a table (Table2) with 10K + rows. Column D is labeled "Master Name." Column E is labeled "Child Name???" I have a VBA that colors the row Gray when a P is in the "Master Name" column. I need to add another Conditional Format that would Bold all of the text in a row where a "c" is in Column E "Child Name???" column. These conditions are not dependant upon each other with the exception that if Column D has a "P", Column E can not have a "c." If a row does not have a "P" or a "c" if should not have any color or bold.

I can't use a regular Conditional Format because it slows my worksheet considerably.


The complete VBA is below - The portion of with the existing Condiitonal VBA is at the bottom. The existing VBA is attached to a command button. The sample worksheet is attached.

I really appreciate your help. I am not very savvy with VBA so I appreciate your patience.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Works GREAT!!!! Thank you so much!!!

You're welcome.