Formula in conditional formatting Archives

Highlight Consecutive Night Shift’s Employee in Excel

December 30, 2023June 25, 2024 PKComments Off

Are you looking to efficiently manage your team's night shifts using Excel? You're in the right place! Our latest video, "Highlight Consecutive Night Shift’s Employee in Excel" has all the

Charts and Visualization

Waffle chart with Football Icon in Excel

March 9, 2023May 21, 2024 PKComments Off

Data visualization is important part of data analysis. It enables us to better understand the data, identify trends, and make informed decisions. There are several types of charts and graphs

Highlight selected Row and Column in Data

Excel Tips and Tricks

Highlight Row and Column of Active Cell in Data Automatically

March 2, 2023August 2, 2024 PKComments Off

Data analysis is an essential part of any business. Microsoft Excel is a great tool for organizing, analyzing, and visualizing data. It can be challenging to read through large tables

Charts and Visualization

Multi-color Data bar with REPT function

July 12, 2022August 10, 2024 PKComments Off

In this article, we have created multi-color Data bar with REPT function in Excel. We have used the conditional formatting to change the color based on certain criteria. Multi-color Data

Templates

Dynamic Calendar with Single formula

March 13, 2022August 11, 2024 PKComments Off

In this article, we have created a dynamic calendar in Microsoft Excel. We have used a Single formula to create this Dynamic Calendar. We have displayed two form control Spin

Templates

Send WhatsApp and Email without VBA

January 17, 2022April 3, 2024 PKComments Off

In today's fast-paced world, communication has become an integral part of our lives. We need to stay connected with our colleagues, friends, and family. WhatsApp and Email are two of

Templates

Automated Attendance Sheet in Excel

December 6, 2020April 13, 2024 PKComments Off

Managing attendance can be a time-consuming and challenging task, especially for organizations with a large workforce. With the help of Microsoft Excel, we can create an Automated Attendance Sheet to

Charts and Visualization

Multicolor Filling Bars in Excel Cells Without using Chart

August 16, 2020June 15, 2024 PKComments Off

In the article, you will learn how to create Multicolor Filling Bars in Excel Cells without using Chart. You can use such visualization to display the project completion status with

VBA Templates

Smart Data Entry form with minimum VBA

December 23, 2019April 9, 2024 PKComments Off

In this article, we have a Smart data entry form for candidate information with minimum VBA. We have used Excel formulas, conditional formatting and Form Controls. You can replicate this

Templates

Daily Activity Tracker in Excel

November 4, 2019July 26, 2024 PKComments Off

In this article, we have created a simple Daily Activity Tracker in Excel. You can use this Activity tracker to track your daily activity and you can create a database