Help : Looping and Conditional Formating

[anish.ms]

Hi Experts,

I have attached a sample file with some codes and request your help in the following areas -

Sheet("Receivable") - To populate the total bill amount against client names in respective months from Sheet('Tracker")
And conditional formatting of the total amount based on the collection amount. Fill in green if completely collected, no color if completely pending and in case of part collection, fill the collection % in green.
I have given the expected results in sheet("Example")

Thanks in advance!