在调整Excel单元格格式时，对颜色编码进行了整理，分享给大家！
根据已有的HEX格式，填充对应的颜色能够更加的直观体现。
import openpyxl
from openpyxl.styles import PatternFill,Color
color_path = r'十六进制颜色编码表.xlsx'
wb = openpyxl.load_workbook(color_path)
ws = wb.active
cell_range = ws["F2:F136"]
for row in cell_range:
for cell in row:
# 定义填充样式
pattern_fill = PatternFill(patternType='solid', fgColor=Color(rgb=cell.value))
cell.fill = pattern_fill
wb.save(color_path)
wb.close()
结果呈现：
十六进制颜色表序号英文代码形像颜色HEX格式RGB格式对应颜色1White纯白#FFFFFF255,255,255FFFFFF2Ivory象牙色#FFFFF0255,255,240FFFFF03LightYellow浅黄色#FFFFE0255,255,224FFFFE04LemonYellow柠檬黄#FFFF00255,255,0FFFF005Yellow黄色#FFFF00255,255,0FFFF006Snow雪#FFFAFA255,250,250FFFAFA7FloralWhite花的白色#FFFAF0255,250,240FFFAF08LemonChiffon柠檬薄纱#FFFACD255,250,205FFFACD9Cornislk玉米色#FFF8DC255,248,220FFF8DC10SeaShell海贝壳#FFF5EE255,245,238FFF5EE11LavenderBlush偏红的淡紫色#FFF0F5255,240,245FFF0F512PapayaWhip番木瓜#FFEFD5255,239,213FFEFD513BlanchedAlmond漂白的杏仁#FFEBCD255,235,205FFEBCD14MistyRose薄雾玫瑰#FFE4E1255,228,225FFE4E115Bisque（浓汤）乳脂，番茄等#FFE4C4255,228,196FFE4C416Moccasin鹿皮鞋#FFE4B5255,228,181FFE4B517NavajoWhiteNavajo白#FFDEAD255,222,173FFDEAD18PeachPuff桃色#FFDAB9255,218,185FFDAB919Gold金#FFD700255,215,0FFD70020Pink粉红#FFC0CB255,192,203FFC0CB21LightPink浅粉色#FFB6C1255,182,193FFB6C122Orange橙色#FFA500255,165,0FFA50023LightSalmon浅鲜肉（鲑鱼）色#FFA07A255,160,122FFA07A24DarkOrange深橙色#FF8C00255,140,0FF8C0025Coral珊瑚#FF7F50255,127,80FF7F5026HotPink热情的粉红#FF69B4255,105,180FF69B427Tomato番茄#FF6347255,99,71FF634728OrangeRed橙红色#FF4500255,69,0FF450029DeepPink深粉色#FF1493255,20,147FF149330BrightPurple亮紫色#FF00FF255,0,255FF00FF31PurePurple纯紫#FF00FF255,0,255FF00FF32Red纯红#FF0000255,0,0FF000033OldLace老饰带#FDF5E6253,245,230FDF5E634LightGoldenrodYellow浅秋麒麟黄#FAFAD2250,250,210FAFAD235Linen亚麻布#FAF0E6250,240,230FAF0E636AntiqueWhite古代的白色#FAEBD7250,235,215FAEBD737Salmon鲜肉（鲑鱼）色#FA8072250,128,114FA807238GhostWhite幽灵的白色#F8F8FF248,248,255F8F8FF39MediumSpringGreen适中的春天的绿色#F5FFFA245,255,250F5FFFA40WhiteSmoke白烟#F5F5F5245,245,245F5F5F541Wheat小麦色#F5DEB3245,222,179F5DEB342SandyBrown沙棕色#F4A460244,164,96F4A46043Azure蔚蓝色#F0FFFF240,255,255F0FFFF44Honeydew蜂蜜#F0FFF0240,255,0F0FFF045AliceBlue爱丽丝蓝#F0F8FF240,248,255F0F8FF46Khaki卡其布#F0E68C240,230,140F0E68C47LightCoral淡珊瑚色#F08080240,128,128F0808048PaleGodenrod灰秋麒麟#EEE8AA238,232,170EEE8AA49Violet紫罗兰#EE82EE238,130,238EE82EE50DarkSalmon深鲜肉（鲑鱼）色#E9967A233,150,122E9967A51Lavender薰衣草花的淡紫色#E6E6FA230,230,250E6E6FA52LightCyan淡青色#E1FFFF225,255,255E1FFFF53BrulyWood结实的树#DEB887222,184,135DEB88754plum李子#DDA0DD221,160,221DDA0DD55GainsboroGainsboro#DCDCDC220,220,220DCDCDC56Crimson猩红#DC143C220,20,60DC143C57PaleVioletRed苍白的紫罗兰红色#DB7093219,112,147DB709358GoldEnrod秋麒麟#DAA520218,165,32DAA52059Orchid兰花的紫色#DA70D6218,112,214DA70D660Thistle蓟#D8BFD8216,191,216D8BFD861LightGray浅灰色#D3D3D3211,211,211D3D3D362Tan晒黑#D2B48C210,180,140D2B48C63Chocolate巧克力#D2691E210,105,30D2691E64Peru秘鲁#CD853F205,133,63CD853F65IndianRed印度红#CD5C5C205,92,92CD5C5C66MediumVioletRed适中的紫罗兰红色#C71585199,21,133C7158567Silver银白色#C0C0C0192,192,192C0C0C068DarkKhaki深卡其布#BDB76B189,183,107BDB76B69RosyBrown玫瑰棕色#BC8F8F188,143,143BC8F8F70MediumOrchid适中的兰花紫#BA55D3186,85,211BA55D371FireBrick耐火砖#B22222178,34,34B2222272PowDerBlue火药蓝#B0E0E6176,224,230B0E0E673LightSteelBlue淡钢蓝#B0C4DE176,196,222B0C4DE74PaleTurquoise苍白的绿宝石#AFEEEE175,238,238AFEEEE75GreenYellow绿黄色#ADFF2F173,255,47ADFF2F76LightBLue淡蓝#ADD8E6173,216,230ADD8E677DarkGray深灰色#A9A9A9169,169,169A9A9A978Brown棕色#A52A2A165,42,42A52A2A79Sienna黄土赭色#A0522D160,82,45A0522D80DarkOrchid深兰花紫#9932CC153,50,2049932CC81PaleGreen苍白的绿色#98FB98152,251,15298FB9882DarkVoilet深蓝紫色#9400D3148,0,2119400D383MediumPurple适中的蓝紫色#9370DB147,112,2199370DB84LightGreen淡绿色#90EE90144,238,14490EE9085DarkSeaGreen深海洋绿#8FBC8F143,188,1438FBC8F86SaddleBrown马鞍棕色#8B4513139,69,198B451387DarkPurple深紫色#8B008B139,0,1398B008B88DarkRed深红色#8B0000139,0,08B000089BlueViolet深紫罗兰的蓝色#8A2BE2138,43,2268A2BE290LightSkyBlue淡蓝色#87CEFA135,206,25087CEFA91SkyBlue天蓝色#87CEEB135,206,23587CEEB92Gray灰色#808080128,128,12880808093Olive橄榄绿#808000128,128,080800094Purple紫色#800080128,0,12880008095Maroon栗色#800000128,0,080000096BabyGreen绿玉#7FFFAA127,255,1707FFFAA97Chartreuse查特酒绿#7FFF00127,255,07FFF0098LawnGreen草坪绿#7CFC00124,252,07CFC0099MediumSlateBlue适中的板岩暗蓝灰色#7B68EE123,104,2387B68EE100LightSlateGray浅石板灰#778899119,136,153778899101SlateGray石板灰#708090112,128,144708090102Beige米色（浅褐色）#6B8E23107,142,356B8E23103SlateBlue板岩暗蓝灰色#6A5ACD106,90,2056A5ACD104DimGray暗淡的灰色#696969105,105,105696969105CornflowerBlue矢车菊的蓝色#6495ED100,149,2376495ED106CadetBlue军校蓝#5F9EA095,158,1605F9EA0107OliveDrab橄榄土褐色（褐绿色）#556B2F85,107,47556B2F108Indigo靛青#4B008275,0,1304B0082109MediumTurquoise适中的绿宝石#48D1CC72,209,20448D1CC110DarkSlateBlue深岩暗蓝灰色#483D8B72,61,139483D8B111SteelBlue钢蓝#4682B470,130,1804682B4112RoyalBlue宝蓝#4169E165,105,2254169E1113Turquoise绿宝石#40E0D064,224,20840E0D0114SpringGreen春天的绿色#3CB37160,179,1133CB371115LimeGreen酸橙绿#32CD3250,205,5032CD32116DarkSlateGray深石板灰#2F4F4F47,79,792F4F4F117SeaGreen海洋绿#2E8B5746,139,872E8B57118ForestGreen森林绿#228B2234,139,34228B22119LightSeaGreen浅海洋绿#20B2AA32,178,17020B2AA120DodgerBlue道奇蓝#1E90FF30,144,2551E90FF121MidnightBlue午夜的蓝色#19197025,25,112191970122Aqua，Cyan水绿色，青色#00FFFF0,255,25500FFFF123MintCream薄荷奶油#00FF7F0,255,12700FF7F124Green绿色#00FF000,255,000FF00125MediumAquamarine适中的碧绿色#00FA9A0,250,15400FA9A126DarkTurquoise深绿宝石#00CED10,206,20900CED1127DeepSkyBlue深天蓝#00BFFF0,191,25500BFFF128DarkCyan深青色#008B8B0,139,139008B8B129Teal水鸭色#0080800,128,128008080130DarkGreen深绿色#0064000,100,0006400131Blue蓝色#0000FF0,0,2550000FF132MediumBlue适中的蓝色#0000CD0,0,2050000CD133DarkBlue深蓝色#00008B0,0,13900008B134Navy海军蓝,深靛蓝#0000800,0,128000080135Black纯黑#0000000,0,0000000