Excel Script for Numeric Value Modification

I need a script that modifies three Excel columns based on specific numeric inputs.

Requirements:
- Modify numeric values based on player skin color
- Use fixed values for each color group

Ideal Skills and Experience:
- Proficiency in Excel and scripting languages (e.g., Python, VBA)
- Experience with conditional logic and data manipulation in Excel



This is for a Madden 05 mod. I am trying to make the players on the excel sheet reflect their accurate skin color in the game. I have set numbers for the 3 columns for a white player and also for an African American player. Doing this one by one is very time consuming to say the least. So I was wondering if someone could create a script to where it automatically matches the correct number value to match the players skin color. There are 3 columns that change the skin color. All other columns must remain the same.k


The 3 columns that need to be changed are

U,AF, and DK


White player-

U-2
AF-0
DK-125


African American player

U-1
AF-5
DK-1


Also, it would be great if I could use this script in the future.