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 my previous post Lesson#29: Explaining CONDITIONAL FORMATTING very simply I explained CONDITIONAL FORMATTING. In this post, I will show how to modify CONDITIONAL FORMATTING by using a formula. 1st you have to select the area where you want to apply CONDITIONAL …
Lesson#30: Modify CONDITIONAL FORMATTING by using formula Read more »
CONDITIONAL FORMATTING highlights the cells with a certain color, depending on the cell’s value. It allows you to distinguish those cells of the given criteria in the spreadsheet. This is a very essential feature of excel. In this post, I …
Lesson#29: Explaining CONDITIONAL FORMATTING very simply Read more »