Trying to run an if then in a cell based on an if then from another cell

I am trying to run an If Then in column J that will tell me weather or not to color a cell in column G with a sub If Then that will change the color of the cell.

I must be missing something because the macro runs without an issue but I'm not getting the desired results .... any help would be appreciated.

Please Login or Register  to view this content.

protonLeah, The cells I'm coloring are dates and I'm changing the colors based on how past due the dates are compared to today's date (Now).

Winon, because I'm adding to existing code that works (changing the cell colors based on dates) and am only now wanting to change those colors based on changes in another cells.

Thank you both for looking at this.

Thank you all for your help. Having grown up with Macros it was my only thought but I on suggestion I went with conditional formatting and after playing with am a true believer. Again, thank you.