title: ColdFusion 2021 SpreadsheetFormatCell colors
body: <p>Recently upgraded to CF2021 from CF11. I have a spreadsheet that we format cells, rows, and columns with colors, particularly background colors. I specify either color= or fgcolor=. No matter what color I choose, it will be black. I've searched and searched but find nothing for 2021.</p>
  <p>Anybody have a solution?</p>
  <p>Very simplified code. It works in CF11 and CF2016.</p>
  <pre><code>&lt;cfscript&gt;
      sObj = SpreadsheetNew(&quot;Testing Summary&quot;,&quot;yes&quot;);
      SpreadsheetSetCellValue(sObj,&quot;As of: &quot; &amp; DateFormat(#DateAdd(&quot;h&quot;, -1, Now())#),1,1); 
      SpreadsheetFormatCell(sObj, {bold=&quot;true&quot;, fontsize=&quot;14&quot;}, 1,1);
      SpreadsheetMergeCells(sObj,1,1,1,5);
      SpreadsheetSetCellValue(sObj,&quot;Testing Summary&quot;,2,1); 
      SpreadsheetMergeCells(sObj,2,2,1,5);
      SpreadsheetFormatCell(sObj, {bold=&quot;true&quot;, fontsize=&quot;20&quot;, fgcolor=&quot;blue&quot;, color=&quot;yellow&quot;}, 2,1);
  &lt;/cfscript&gt;
  
  &lt;!--- Launch File to User ---&gt;
  
  &lt;cfheader name=&quot;Content-Disposition&quot; value=&quot;attachment; filename=MySpreadsheet.xlsx&quot;&gt; 
  &lt;cfcontent type=&quot;application/vnd.ms-excel&quot; variable=&quot;#SpreadsheetReadBinary( sObj )#&quot;&gt; 
  </code></pre>