Comparison Between Column Values and Highlighting with VBA Code

I need your expert opinion on this. We have data like this;
M column is unique data extracted from Column A as you can see.

we want to compare Column N with Column O and if both of them match, then we need to highlight From Column M, N, O and P with red color (see highlight red in sheet).

For example: For the Client Bryan in Column M if N = 1 and O = 1 then I need to apply the above highlight From Column M to P with red color. And by default if Column O is 0 (zero) then I need it to highlight with background color yellow (see highlight yellow in sheet).

This i need to be applied/copied down to other rows below based on Last Row of Column M.

we can do this using conditional formatting but its time consuming. Hence I need a VBA code to automate this thing to save a lot of time.

Thanks everyone in this forum. I am learning a lot from this website, but some things are way beyond my scope of understanding and need excel experts opinion as always who are ready with their suggestions and come out to help us. Highly appreciate all of your efforts and time. Thanks again.

how do i modify this =AND($O2=0,ISNUMBER($O2)) ?

as this even fills up all the blank cells with the formula...kind of stuck

well...not even one response...so far.....hmmmm....