sharc316
05-01-2017, 06:29 PM
Hi,
I'm looking for a quick way to reconcile the accuracy of VBA formatting by matching totals from VBA extracted sheets to statement total.
Basically would like to look for a value in column A "Total" then depending on which row this text is in would like to compare the number in Column N to the number in cell A3. The A3 cell is static and won't change, meaning the value will always be in that cell.
If the number from column N matches the number in cell A3 then would like A3 highlighted in green. If it does not match, then highlight A3 in red.
Thank you for your help.
I'm looking for a quick way to reconcile the accuracy of VBA formatting by matching totals from VBA extracted sheets to statement total.
Basically would like to look for a value in column A "Total" then depending on which row this text is in would like to compare the number in Column N to the number in cell A3. The A3 cell is static and won't change, meaning the value will always be in that cell.
If the number from column N matches the number in cell A3 then would like A3 highlighted in green. If it does not match, then highlight A3 in red.
Thank you for your help.