I am new to Access, so please forgive me if this has been asked before. I have carried out a search on the site but could not find a clear answer.
I would like to export a datasheet form to Excel including conditional formatting.
- I have a query with several lookup tables.
- A form is based on the query with a datasheet view only.
- I have set up conditional formatting where a field changes color in certain cells based on the selected from the pick list.
I would like the user to export this via a button to a spreadsheet. I have tried this, but the exported data in the spreadsheet does not include conditional formatting or the data type.
Would be grateful for advice on how I do this.
I would like to export a datasheet form to Excel including conditional formatting.
- I have a query with several lookup tables.
- A form is based on the query with a datasheet view only.
- I have set up conditional formatting where a field changes color in certain cells based on the selected from the pick list.
I would like the user to export this via a button to a spreadsheet. I have tried this, but the exported data in the spreadsheet does not include conditional formatting or the data type.
Would be grateful for advice on how I do this.