Allow colour to be set in a similar fashion to value (with Range)
It would be good if colour (and other formatting) could be set in the same manner as value. For example setting Range("A1").color = [(0, 0, 0), (255, 0, 0), (0, 255, 0), (0, 0, 255)] would set the first 4 cells in the row to black, red, green, blue.
It would be good to be able to run map functions on lists/series/dataframes to generate formatting. In my case I want to be able to mark positive/negative regression with color.
It's possible to do this manually, but it is slow to iterate over all the cells in the data.
2
votes
Matt Shepherd
shared this idea