Highlight matching cells based on manual text

    I've searched and searched and so on. My apologies if this is here somewhere, but I can't find a match for what I'm trying to do specifically.


    I have a list of names in Column B (Starting at B5) with assignments to them in Column A. I want the people who receive the file, to enter their name in B1 exactly as it appears multiple times in sheet. And hope to use conditional formatting to highlight (change the back ground color) of each cell their name appears in.


    I've used a number of formulas in the Conditional formatting including "=(ISNUMBER(MATCH($B5:$B100,$B$1,0)))", Countif's and "Not(isnumber)..." but can't find a formula that picks up the whole text.


    I'm not too savvy with VBA, but can cut and paste a code into it with no problems :)


    If there's anyone that can help me, I would greatly appreciate it!!


    Thank you!

    Re:

    Code
    Highlight matching cells based on manual text


    Would you be better to have a list of names, like you have in cell 'B5' and put a drop-down list into the cells you want them to type their name. That way there will be no mistake.


    In your conditional format you would select "Format Cells that only Contain" Then select 'Cell Value', 'Equal to' 'B1'


    ???

    Re:

    Code
    Highlight matching cells based on manual text


    Hi BenC1985!!


    Possibly - but I have 5 days (tabs) which different names show up on different tabs plus any name that has shown up on previous days (tabs). I could create a range for each day, but I thought there had to have been an easier way to highlight cells duplicated based on the value of a specific cell.


    ya? no?

    Re:

    Code
    Highlight matching cells based on manual text


    OMG!!! Pretty Embarrassed at this point... seems to be pretty simple when I change the range. :/ Sorry - But thank you for your help!~

Participate now!

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

Register Yourself Login