| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change Excel Cell forecolor using VB6
Hi there,
I am exporting data from ACCESS database to EXCEL Spreadsheet. If the Sales value is below certain value, I like to forecolor for a specific row to be RED in color. Tried using this code in VB6 and it's not working: objWorksheet.Cells(intRow, intCol).Fill.SchemeColor = vbcolor |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change Excel Cell forecolor using VB6
objWorksheet.Cells(intRow, intCol).Interior.ColorIndex = 5 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change Excel Cell forecolor using VB6
I wonder if you might need to use the RGB Color scheme.
-- HTH, Barb Reinhardt "Lennie" wrote: Hi there, I am exporting data from ACCESS database to EXCEL Spreadsheet. If the Sales value is below certain value, I like to forecolor for a specific row to be RED in color. Tried using this code in VB6 and it's not working: objWorksheet.Cells(intRow, intCol).Fill.SchemeColor = vbcolor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change forecolor with code | Excel Discussion (Misc queries) | |||
| EXCEL change which cell is selected next | Excel Discussion (Misc queries) | |||
| Enter 1 in a cell, excel change to 0.001, WHY? | Excel Worksheet Functions | |||
| Is there a way you can get Excel to change an image in a cell | Excel Discussion (Misc queries) | |||
| excel deleting rows last cell does not change. How to change? | Excel Discussion (Misc queries) | |||
Linear Mode
