In excel am having table and I need to validate the sum of the table by inserting a row at the end of the table and calculating sum excluding the above row to the inserted once, because that row is sum of the above all items and highlight with any color if the sum is exactly matched with the above one and highlight with any other color if sum is not matched.
Amounts are always presented in numbers [ “ 0-9” ] Comma [“ , ”] Space [ “ ”] Dot [“.”] If anything presented other this formats it should highlight that cell….
Please anyone automate this using VBA am very thankful to them and please suggest or modify my requirements at their best.
My objective is to validate the sum of the above items and highlight which is not in the above-specified formats…
For reference please find the attachment.