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