I am trying to get Conditional formatting to achieve a result to no avail.

Here is what I'd like it to do:

Column A - if cell, in Row is 0 then shade active Row (ColumnA:ColumnM)YELLOW
THEN if cell in Column J is 0 then shade activated Row (ColumnA:ColumnM)
RED (this supersedes previous format of Yellow)
THEN if cell in Column M is 0 the remove all shading from active Row.

Column A logs in that something was received, Column J means the received
item was rejected and must be re-submitted, Column M is the close out showing
final has been approved.

Can this be written as a formula or does this need VBA?

Thank you.

--
Thank you,