VBA to highlight row and limit

[ANE0709]

Not sure how to word that but i started writing a change event that highlights the row if certain conditions are met. im still very much learning change events and highlighting using VBA so im not sure how to work this, what i have is a start but probably far off. Basically the conditions i am trying to meet are:

Highlight columns A-AP if:
if the value of column C = C then highlight row green (color 5296274)
if column I <> 0 then highlight yellow (color index 6)
if column I and column L <> 0 then highlight yellow (color index 6)
if column J and column L <> 0 then highlight purple (color index 39)

Should there be a conflict with column C, I, and J i want column C to take priority. This shouldnt ever happen unless there is user error but just in case.

Columns C and I-P are all manual entry by the user.

 

[ANE0709]

Have you test my earliest code in #17?
It trigger change from row 4, and update the color automaticaly.

yes, it works just as well and just as fast as JohnnyL's and solves the color change bug.

Both solutions are great and i will be keeping both versions for future projects! its late for me, have a good night!