Hi,
I frequently use the following conditional formatting for a lot of my Excel files' cells:
98,0% and below = Red fill
Between 98,0% - 98,5% = Yellow fill
98,5% and above = Green fill
However, it costs me a lot of time doing this manually many times per day. It would be really beneficial to have a Quick Access macro in which I can highlight all the cells I want formatted, and simply press the button to do the formatting for me.
Does anyone know how this VBA code would look? I know how to add the button to the toolbar, but am at a complete lost code-wise.
Many thanks for any help on this one!
Bookmarks