Lesson#48: Graphical 20X20 multiplication table
In this post, I will make a graphical 20X20 multiplication table and show the process of …
Tag: CONDITIONAL FORMATTING
Lesson#43: Make an ON/OFF switch for Conditional Formatting in your excel sheet
Showing a random example worksheet where I have used conditional formatting and color formatting. Now I …
Lesson#43: Make an ON/OFF switch for Conditional Formatting in your excel sheet Read more →
Lesson#42: Tricks to color alternate rows or columns of the entire sheet at once
Select the entire sheet by clicking on the most left upper corner of the sheet or …
Lesson#42: Tricks to color alternate rows or columns of the entire sheet at once Read more →
Lesson#39: Cool tricks to make automatically updating Gantt chart
Hi, friend today I will show you how to make an automatically updating Gantt chart without …
Lesson#39: Cool tricks to make automatically updating Gantt chart Read more →
Lesson#30: Modify CONDITIONAL FORMATTING by using formula
In my previous post Lesson#29: Explaining CONDITIONAL FORMATTING very simply I explained CONDITIONAL FORMATTING. In this post, I …
Lesson#30: Modify CONDITIONAL FORMATTING by using formula Read more →
Lesson#29: Explaining CONDITIONAL FORMATTING very simply
CONDITIONAL FORMATTING highlights the cells with a certain color, depending on the cell’s value. It allows …
Lesson#29: Explaining CONDITIONAL FORMATTING very simply Read more →