Highlight cells which have no dependents or duplicate dependents

Dear All, Hi

I have a two worksheets of workbook named LC worksheet and second one Account work sheet. Data from LC worksheet likned into the Account worksheet at Column K and Column V.

I want to highlight cells in LC worksheet which have no dependents or have duplicate dependents at Column K and Column V into the Account worksheet. Built in trace dependents is time consuming and useless.

File attached for your further understanding

Please help me by coding macro or other feasible programming.