I want to color a world map with the colors I obtained in Excel trough conditional formatting. The process is automatic but I need the HTML code of the colors for each individual cell (there are 229 cells so manual solutions are off the tamble) of a range of cells that was colored trough a conditional formatting rule. Problem is all solutions I found online so far only work for cells that are not "conditional formatted" ie. their fill color was set manually.
The file I'm using to automatically color the map can be found here: https://app.box.com/s/yxur2ea2r7cswct80hdz
A solution like this that would work for conditionally formatted cells and return the result in HTML color code would be ideal: https://stackoverflow.com/a/14283150/4214058
Thanks in advance for any help
