I have a spreadsheet that has a colour key at the top. Users are expected to manually set the colour of various cells in the spreadsheet in line with the colour key.
Ideally what I'd like is for users to be able to highlight/select one or more cells in the spreadsheet they wish to give a colour to, then with one click on the colour key cell be able to copy its interior colour to the cells they selected originally.
User selects cells A17:D17 and wants to set the interior colour of those cells the same as the interior colour of cell A2 just by clicking on cell A2.
They might then want to change the colour of A17:D17 to the same colour as A3 just by clicking on cell A3
Is there a macro/custom function/combobox way of doing this?
Any advice would be greatly appreciated
以上就是copy cell interior color from clicked cell to active cell的详细内容，更多请关注web前端其它相关文章！