Criteria for color and columns

HI I have below code which color the rows after amount in column J.
What I really need is this. There is 4 column with approvals. From column M to P.

If the color is green I need a message box come up, if there is no date in Column M.

If the color is ´Light blue, I need a message box come up, if there is missing date in any of column M and N


If color is Pink, I need a message box come up, if there is not data in any of column M, N and O

If color is orange I need a message box come up if no data in any of Column M, N, O and P.

The message box could say "there is missing comment for items in green etc"

In below code which I get great help to here.- It color all rows. So here is the correct color codes. And maybe this Macro can be build out.

Or a separate macro is fine also.

I have also attached a test sheet, where you can see the colors and here in a module the code below is.

I would really like if I in the code can change easy the columns if it should change.


Please have a look also at below test sheet,

Thanks in advance

Sincerely

Abjac

Please Login or Register  to view this content.

Looks like my code. Does this do what you need?

Please Login or Register  to view this content.

HI stnkynts. Yes it was your code. Thanks really allot for this one. I really save my day. I need check this in a big sheet and it works fantastic.
Really great code.

Really great help from you.

Thanks allot

Have a nice day

Sincerely

Abjac

Try this:

Please Login or Register  to view this content.

HI stnkynts,. Again a very good code. I Just tested it and it works really perfect.
Thanks allot great help again.

have a nice day.

Sincerely
Abjac