So here I will show you a simple but very useful trick with Conditional Formatting. This is about how to highlight a particular number in an array automatically. So in the above picture, I have a number array where I …

Lesson#90: How to highlight a particular number in an array automatically Read more »

Previously I have discussed in a post Lesson#39: Cool tricks to make automatically updating Gantt chart without using an excel chart It was a day-wise scheduling format. Here I will show how to make a month-wise scheduling format. First I …

Lesson#87: How to make month wise auto-updating program schedule Read more »

We will learn how to make an automatically refreshing bar clock in excel. 1. First I made three merged cells by putting these formulas =HOUR(NOW()) =MINUTE(NOW()) =SECOND(NOW())   2. Select those cells one by one and click on Conditional Formatting>Data …

Lesson#80: Make an automatically refreshing bar clock in Excel Read more »

Let me show you how to make a spreadsheet that changes its color every second automatically. to make this you have to follow some steps where I will apply a little VBA to make it really automatic. 1. Click the …

Lesson#79: Automatic changing Excel sheet color every second Read more »

Now I will show how to make a spreadsheet that changes its color every minute automatically. to make this you have to follow some steps. 1. Click the upper left corner of the sheet to select all of the spreadsheets. …

Lesson#78: Change the color of the whole sheet every minute in Excel Read more »

Here I have got a case where my colleague was working with a project schedule. He had a schedule with a start date, end date, and scope and he had to break up the scope month-wise. With a long schedule, …

Lesson#77: Scope the breakup program schedule and explain the formula Read more »

This is a project schedule format where I have a list of dates and works. I need to color all the Sundays in the list of dates and for that, I will use a simple trick. Select all the dates …

Lesson#53: Simple trick to color all the Sundays in the list of dates at once Read more »

Here I have to make a parent Gantt chart from a data table. It is a Gantt chart summary as per BOQ (Bill of Quantities) Item and RA Bill No. wise. This bar chart will be followed with chainage value …

Lesson#49: Make a parent Gantt chart from a data table Read more »

Showing a random example worksheet where I have used conditional formatting and color formatting. Now I will make a switch that will trigger the Conditional Formatting ON or OFF. Besides the table, I have made a drop-down list of  ON/OFF …

Lesson#43: Make an ON/OFF switch for Conditional Formatting in your excel sheet Read more »