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 t...
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.