Hello All,
I have an excel worksheet with many sub-totals and a Grand Total. I have faced issues many times where a User add's a new row but forgets to check the sub-total and grand total to ensure the value on this new row is picked up. This results in delays in the process and having to do re-works and impact efficiency. So my question is can you suggest if its possible to have a color coding in Excel. So if a User adds a new row in the worksheet the sub total and grand total row's change color. This will ensure that the user and reviewer can check the formula and make corrections before submission. Appreciate your help.