• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • Last Modified:

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.
1 Solution
objSpreadsheet.Cells(1,1).Interior.Color = RGB(229,229,231)
' or whatever you have your spreadsheet called or
objSpreadsheet.Cells(1,1).Interior.Color = vbRed
rkulpAuthor Commented:
Thank you.  Works like a champ.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now