Here I will make a formula in Conditional Formatting. This formula will color cells if the cell value is found in another column. For example, I am showing this picture below. If the value is present in column A then …

Lesson#140: Color cells if cell value found in another column – Conditional formatting Read more »

Here I will discuss a long topic about Excel Gantt chart making. I will show how I made my excel chart work like the ms project schedule by adding some basic features. Some basic features of the ms project which …

Lesson#107: How did I add MS Project features to the Excel project schedule 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 »