+ Reply to Thread
Results 1 to 6 of 6

Color Name after check skills.

  1. #1
    Registered User
    Join Date
    01-13-2011
    Location
    Beneden-Leeuwen, Netherlands
    MS-Off Ver
    MS Excel 365
    Posts
    13

    Post Color Name after check skills.

    I want to color a name after checking skills. For instance: I want to check if Alex skills (G2 to J2) in the skills area matches with the column with skills in column A4 to A7. If Alex doesn't has the BJ skill (empty in I2) then his name cell gets another color in B3. (red or another)
    This has to be build in a looping, so that a macro checks this for every person (5 persons) in column B3-B7.
    If a person doesn't have two skills then he gets another color or different formatting.
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Color Name after check skills.

    You don't need VBA. You can use Conditional Formatting. See the attached updated example.

    For example:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    for red

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    for amber, and

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    for yellow
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    01-13-2011
    Location
    Beneden-Leeuwen, Netherlands
    MS-Off Ver
    MS Excel 365
    Posts
    13

    Post Re: Color Name after check skills.

    Thanks for your first solution.
    I want to compare the 4 positions to the left of the names with the skills in the table. This applies to every new row/column of names.
    The names may be colored if the person does not master 2 or more skills in the column of 4 skills/positions.
    I started with your first solution, but this isn't the right solution for my question.
    How can I make this work...(see file)
    Attached Files Attached Files

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Color Name after check skills.

    That is a far more complex model than the example you first posted.

    Are you still using Excel 2003? If not, please update your profile.

  5. #5
    Registered User
    Join Date
    01-13-2011
    Location
    Beneden-Leeuwen, Netherlands
    MS-Off Ver
    MS Excel 365
    Posts
    13

    Re: Color Name after check skills.

    Updated profile.

    Another solution to this sheet is to compare the range of skills with the place to work. The skill range is A,B,PP,DB,UP,JP etc. The value in the range for each employee will be compared with the place to work (4 rows, 5 employees/ like AR4, AR5, B, UP) If a employee has no skills to work at least at tree places his name will color for instance Red or other formatting.
    I could change the skills in A = AR, etc. for a easy search with instr. and compare. And I could place the skills just after the name's (next column).

    I'm looking for the right code to enable my skills check.

    Regards in advance.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Color Name after check skills.

    Please see if the attached example works for you.

    Note the comments: I have added Data Validation to avoid some errors. The formulae for the top blocks need to be adjusted when copied to the lower blocks.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 19
    Last Post: 03-31-2021, 02:03 PM
  2. Change check box fill color to unfill and clear check mark
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2020, 03:20 PM
  3. Check boxes that delete other check boxes and change the color of another cell.
    By nhamhamilton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2014, 02:40 PM
  4. vlookup and condition? matching employee's skills and Ticket skills
    By yannc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2014, 03:27 PM
  5. Looking to shake the dust of my Excel skills and old Algebra skills using Excel
    By twolittlehorses4me in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 11-21-2012, 07:05 AM
  6. Check and color a cell if ... (VBA)
    By cambridge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2010, 04:20 PM
  7. Check for Font Color
    By scantor145 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2010, 09:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1