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 »
Select the entire sheet by clicking on the most left upper corner of the sheet or by pressing Ctrl+A. Now for coloring alternate rows of the entire sheet at once click on Conditional Formatting>New Rule>Use a formula to determine which …
Lesson#42: Tricks to color alternate rows or columns of the entire sheet at once Read more »
Hi, friend today I will show you how to make an automatically updating Gantt chart without using an Excel chart. Here I am making a program schedule with this criteria Activity no, Description, Start Date, End Date, and Days (shown …
Lesson#39: Cool tricks to make automatically updating Gantt chart Read more »
In this post, we will learn to make a calendar which will take input of month from 1 (JAN) to 12 (DEC) and year in numeric format and show the whole month calendar. 1st Step: Make a 2×2 table like …
Lesson#27: How to make a calendar in excel without VBA Read more »
LEN is a function that is used for finding out the number of characters in a text string. Its syntax is LEN(text). THE QUICK BROWN FOX JUMPS OVER THE LAZY DOG has 43 characters including <space> between words. Now I will …
Lesson#22: How to find the exact middle character(s) of text using LEN Read more »
In this lesson, we will learn a method to convert digits into words. I will use functions like CONCATENATE, VLOOKUP, SUM, IF, and MOD, which were discussed in my previous posts. 1st Step I have made a list of relevant …
Lesson#19: How to convert digit into word in excel Read more »