Sum Up Cells Value When Specific Value Match

  • Hi Guys:


    Need your help here,


    How to color code ZONE column according to their respective REGION
    (as per sample below)


    [TABLE="class: cms_table_grid, width: 500"]

    [tr]


    [td]

    Region

    [/td]


    [td]

    Zone

    [/td]


    [td]

    Branch

    [/td]


    [/tr]


    [tr]


    [td]

    North

    [/td]


    [td]

    North A

    [/td]


    [td]

    Branch NA1

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    North B

    [/td]


    [td]

    Branch NB1

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    North C

    [/td]


    [td]

    Branch NC1

    [/td]


    [/tr]


    [tr]


    [td]

    West

    [/td]


    [td]

    West A

    [/td]


    [td]

    Branch WA1

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    West B

    [/td]


    [td]

    Branch WB1

    [/td]


    [/tr]


    [tr]


    [td]

    East

    [/td]


    [td]

    East A

    [/td]


    [td]

    Branch EA1

    [/td]


    [/tr]


    [tr]


    [td]

    South

    [/td]


    [td]

    South A

    [/td]


    [td]

    Branch SA1

    [/td]


    [/tr]


    [tr]


    [td]


    [/td]


    [td]

    South B

    [/td]


    [td]

    Branch SB1

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    South C

    [/td]


    [td]

    Branch SC1

    [/td]


    [/tr]


    [/TABLE]



    Thank you veru much in advance guys [Blocked Image: http://www.vbaexpress.com/forum/images/smilies/001.gif]

  • Re: Sum Up Cells Value When Specific Value Match


    Try this:


Participate now!

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