So here are the basics:
I am working on a large coordination/ scheduling document and want the ability to write a code that would turn certain columns (to be specified in the code by both ranges and single column references) transparent to a certain degree (again specified by code)
This transparency must not interfere with the colors that are selected for dependent on the values in the cell (already set via conditional formatting)
For example: Ideally all cells with a value of 3 would still be red however the transparency of that cell would change dependent on what column the cell is in.
I am new to VBA/Macros and would truly appreciate any insights on this matter. Thanks!
I am working on a large coordination/ scheduling document and want the ability to write a code that would turn certain columns (to be specified in the code by both ranges and single column references) transparent to a certain degree (again specified by code)
This transparency must not interfere with the colors that are selected for dependent on the values in the cell (already set via conditional formatting)
For example: Ideally all cells with a value of 3 would still be red however the transparency of that cell would change dependent on what column the cell is in.
I am new to VBA/Macros and would truly appreciate any insights on this matter. Thanks!
