How to Alternate Shading Row Colors (Banded Rows) While Microsoft Excel does not have a dedicated row banding button to...
Introducing the New 2023 Microsoft Office Color Theme Over the years, we've seen the Microsoft Office suite undergo a plethora...
What This VBA Code Does If you need to convert Hex color codes into the RGB format, the below macro...
What This VBA Code Does There may be times when you need to incorporate coloring your worksheet tabs in your...
What This VBA Code Does The following line of VBA code will allow you to determine if a spreadsheet cell...
What This VBA Code Does Let’s face it, it’s a real pain to change the colors of borders….especially if they...
What This VBA Code Does I ran into an issue where I needed some of my brand colors to be...
What This VBA Code Does If you have ever formatted VBA userforms, you’ve most likely noticed that the color codes...
What This VBA Code Does I recently needed to create a VBA function that tests if a particular shape object...
What This VBA Code Does If you are a formatting nut like me, you will most likely appreciate an issue...
A Little Background This post shows how you can use VBA code to add specific colors (outside your color theme)...
QUESTION How can a find the last cell on a spreadsheet based on a given color? SOLUTION This VBA macro...
What This VBA Code Does Here is a simple VBA macro that will remove any fill colors from your selected...
I've been on a mission the past two weeks to craft a pair of macros to lighten and dark a...
What This VBA Code Does This VBA macro code will allow you to remove a specific fill color from your...
Wishful Thinking? Have you ever had a time where you wished you could write an IF formula in Excel based on...
What This Does Appearance can play a huge factor in the professionalism of your spreadsheet's presentation. Often there are times...
Not So Simple When the Macro Recorder Tries to Play Tricks Today I was writing a macro that automatically highlighted...
[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!