VBA

Blinking Conditional Formatting in Excel

Conditional Formatting is widely used in Excel and it enables us to change Font characteristics and Cell Fill color when a condition is met. In this tutorial I show you how I apply a Blinking Conditio...

Create a Stopwatch or a Countdown Timer in Excel… Step By Step

How to Create a Timer or a Countdown in Excel… Very Useful Creating a Timer/Stop watch in Excel Professionals who are used to organizing their lives in Excel at some point wish Excel could include a t...

Color Hundreds of Sheet Tabs in One Step in Different Colors

To Download the  exercise File and Follow along click Here       Here is the Code Sub ChangeColors() Dim WS As Worksheet Dim IndexColor As Long IndexColor = 50000 For Each WS In Workshe...

Adding a Different Look To Your Interactive Dashboard

Code for Interactive Dashboard Course This code Changes the Background in 4 different colors Switch to the Visual Basic ALT + F11 Insert a Module ALT >I>M Copy and Paste the codes here below the...