Forum Discussion
Colour Module
Hi, I’m trying to create a module for excel based on positive or negative values of certain cells, to be able to,
1. Choose 2 colours: "A" being good, "B" being bad.
2. Alpha and opacity: 0 being the center, below zero the higher the opacity of "B" and vice versa above zero the higher the opacity of "A"
3. Group: which cells to apply to text colour or cell colour.
Is this possible to do for excel?
Thank you for all suggestions and sorry for such a noobish question.
Rgrds.
-AOS.
You can also do it without VBA when it comes to highlighting cells and/or ranges.
Use conditional formatting to highlight information
Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.
