Highlight Cells Matching Selected Cell

  • Hello,

    I don't know if the Title provided is correct or not. Please accept my apology if it is not.

    I would like to select a cell inside my workbook and when it is selected it automatically highlights similar value cells in the same workbook. Is that possible?

    A Look at the attachment should give you a much better idea as to what I am talking about.



  • Re: Selecting Cell Highlights Similar Values In Workbook

    remove conditional formatting from within the red box and put this code in the sheet's code module:

    see attached, p45cal.

  • Re: Highlight Cells Matching Selected Cell

    Thank You very much for such prompt replies.

    It works like a charm.

    Amazing, that all I needed to do was ask.

    Thank you once again for your help.

    You Guys ROK!!!!!!!!!


Participate now!

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