An easy and simple trick to make a color picker will be shown here.
Here I have made a color palette by coloring different cell with different colors. This palette allows us to pick different type of color by selecting cell.
I designated a certain area where the chosen color will be shown.
Now I have inserted a button from developer tab and assigned a simple macro.
Range(“O2:R8”).Interior.Color = ActiveCell.Interior.Color
Where as Range(“O2:R8”) is the designated area for showing the picked color.
Now you have to select any color palette and click on the button to show the color in the O2;R8 area.
Here I have given the file for you.