Shade Row based on Conditional Formatting

I have useful data in Columns A:K. The data (headings) start in Row 4.
Columns M and N have tag data.
I would like to shade the data in rows A:K if the following conditions are met:
*Col M is "Y"
*Col N does NOT equal "Include"

If both conditions are not met for that row, that row (from A:K) should not be shaded.

I recorded the macro below and it works. It adds a conditional format in the worksheet.
However, how would I simplify this code to say: shade those rows where M =X and N is not equal to "Include" without adding a conditional format?

Thank you.

Please Login or Register  to view this content.

Sorry for the confusion: M=X and N is NOT equal to "Include"

You didn't answer the more important question.

Originally Posted by 6StringJazzer

[...]you "recorded the macro below and it works." Are you asking how to use VBA to permanently shade those rows based on that rule, rather than using VBA to create a Conditional Formatting rule to do it?

Yes. I apologize. I would like to shade the rows based on the two conditions without resorting to conditional formatting.

Once again, I apologize, for not being clear.

Does this help?

Please Login or Register  to view this content.