Lesson#103: 4 Ways to find duplicate values in a worksheet
Often we need to find the duplicate values in an Excel worksheet. Here in this post, …
Lesson#103: 4 Ways to find duplicate values in a worksheet Read more →
Tag: CONDITIONAL FORMATTING
Lesson#92: How to highlight a column value depending upon the other column values
Hello Friend! I am back again with my other post. This post is about Conditional Formatting. …
Lesson#92: How to highlight a column value depending upon the other column values Read more →
Lesson#90: How to highlight a particular number in an array automatically
So here I will show you a simple but very useful trick with Conditional Formatting. This …
Lesson#90: How to highlight a particular number in an array automatically Read more →
Lesson#87: How to make month wise auto-updating program schedule
Previously I have discussed in a post Lesson#39: Cool tricks to make automatically updating Gantt chart …
Lesson#87: How to make month wise auto-updating program schedule Read more →
Lesson#80: Make an automatically refreshing bar clock in Excel
We will learn how to make an automatically refreshing bar clock in excel. 1. First I …
Lesson#80: Make an automatically refreshing bar clock in Excel Read more →
Lesson#79: Automatic changing Excel sheet color every second
Let me show you how to make a spreadsheet that changes its color every second automatically. …
Lesson#79: Automatic changing Excel sheet color every second Read more →
Lesson#78: Change the color of the whole sheet every minute in Excel
Now I will show how to make a spreadsheet that changes its color every minute automatically. …
Lesson#78: Change the color of the whole sheet every minute in Excel Read more →
Lesson#77: Scope the breakup program schedule and explain the formula
Here I have got a case where my colleague was working with a project schedule. He …
Lesson#77: Scope the breakup program schedule and explain the formula Read more →
Lesson#53: Simple trick to color all the Sundays in the list of dates at once
This is a project schedule format where I have a list of dates and works. I …
Lesson#53: Simple trick to color all the Sundays in the list of dates at once Read more →
Lesson#49: Make a parent Gantt chart from a data table
Here I have to make a parent Gantt chart from a data table. It is a …
Lesson#49: Make a parent Gantt chart from a data table Read more →