Excel Conditional Formatting in Access VB

[melanemac]

OK, I thought I posted this, but I can't find the post.

Again, I'm working on a programmer's db and would like to automate a feature in Excel, instead of having hard coding from Access.

I have a db that is spitting out data to Excel, line by line. I would like to make the cells have conditional formatting instead of just being formatted one color based upon an if statement.

Does anyone know how to accomplish this?

Thanks!

 

[Brianwarnock]

I think that you will have to do this in Excel and I also think Shades has covered extensive conditional formatting somewhere in that forum.

Brian

 

[Moniker]

There are a lot of ways to do this. If you can do it in Excel, you can do it to Excel from Access (at least as far as formatting is concerned). What have you tried? Where is your code? A "TransferSpreadsheet" will not do.

You need to connect to Excel directly through an Excel object, at which point you have complete formatting control. You determine the format in Access and then export the format to Excel on a cell by cell (or row by row or column by column, etc.) basis. How are you trying to do this, though? Without an example, I can't see where you are potentially going wrong.