Conditional Formatting in Excel

  • 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.

  • Use tables and the problem will go away.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!