Okay, you have to get the row of palette's hex values...like "Red, Blue, Yellow, Orange"
Get the hex value, and stick them together like this:
If Red = 1F00, in VBA it says 001F, so you reverse them then stick them together, with no spaces.
1111000022223333 etc.
Then you search, for it in hex. You will get more than one result, and it usually is the last one...Change the values to a different hex(color) value, and test it in-game.
I do have a tutorial on this too