Can excel extract macro codes of different colors from the same cell?

Thank you very much for your question. In Excel, we can extract the color information of cells through macro code. You can use the interior. The color attribute in VBA code to get the background color of the cell. However, if you want to extract the information of different true colors in the same cell, you need to write custom macro code. In the concrete operation, we can use the Range object and ColorIndex property of VBA to get the background color information of each character in the cell and extract it one by one. However, it should be noted that it may be difficult to extract colors from different parts of cells, and it is necessary to have a certain understanding of VBA programming foundation.