Can I automatically set a cell color in an Excel spreadsheet using VB6?
I test contents of the field values in a recordset. The records are written out to an Excel spreadsheet . I want to be able to set cell color based on the results of the test. I can easily create and populate the worksheet but do not see a way to set the cell color. While a solution is desired, a definitive "can't do that" will earn the points.