shamim
05-18-2019, 06:32 AM
Hi,
In attached excel file sheet there are two columns dedicated for net and vat amount and ultimately the gross amount is comprises by totaling the Net+Vat amount. That means
Net + Vat = Gross amount. If the Gross amount is not matching with sum of Net + Vat then cell interior color should be red.
For better outlook I already change interior color of cell D4 and D5. The total gross amount is not matching with Net+Vat amount.
I want to achieve this process through Macro.
Regards,
Shamim
In attached excel file sheet there are two columns dedicated for net and vat amount and ultimately the gross amount is comprises by totaling the Net+Vat amount. That means
Net + Vat = Gross amount. If the Gross amount is not matching with sum of Net + Vat then cell interior color should be red.
For better outlook I already change interior color of cell D4 and D5. The total gross amount is not matching with Net+Vat amount.
I want to achieve this process through Macro.
Regards,
Shamim