I have a query written in Access that creates a spreadsheet by using TransferSpreadsheet. One of the columns that is being sent is a long representation of the color that I want in that cell only. No text, only a colored cell.
My query results looks like this: Publication Name, Address, City, State, Zip, Publication Type, (the long integer value of some color in this cell), SRDS Code, Release Type, (the long integer value of some color in this cell), Release Date, Market Share.
The columns A-F have data, column G would have a color-filled cell, Columns H-I have data, Column J has some other color, Columns K-L have data.
The colors of the cells in the columns may change for every row written. The columns will not have the same colors in every row.
Is there a way to cause Excel to turn this long integer into a color? The code can't be on the Excel side because the worksheets are created over and over again.