Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 226
- Office Version
- 365
- Platform
- Windows
I attempted to search google for what I am wanting to do but i am getting only results on excel specific VBA or Conditional formatting as opposed to using a Yes or No value entered into an Access form and changing an Excels Cell Fill color.
I have a working Macro that is exporting Form information to specific Cells into a premade Excel report template (Access does not have additional picture formatting we require in our reports)
Elsewhere in the template We have a simple list of Documents and Cell for Yes and a Cell for No and normally we would just highlight manually what document type we require to change.
is it possible in VBA that i can basically put a Drop down or Check box in the ACCESS Form to signify Yes or No and based on that value at the time of export that it can highlight a targeted cell yellow?
OP Edit:
I did realize I could essentially set up the Template that if the field next to the Yes No cells are not blank they can conditionally be formatted to Highlight however for my future understanding is my question above possible?
I have a working Macro that is exporting Form information to specific Cells into a premade Excel report template (Access does not have additional picture formatting we require in our reports)
Elsewhere in the template We have a simple list of Documents and Cell for Yes and a Cell for No and normally we would just highlight manually what document type we require to change.
is it possible in VBA that i can basically put a Drop down or Check box in the ACCESS Form to signify Yes or No and based on that value at the time of export that it can highlight a targeted cell yellow?
OP Edit:
I did realize I could essentially set up the Template that if the field next to the Yes No cells are not blank they can conditionally be formatted to Highlight however for my future understanding is my question above possible?
Last edited:
