• Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS – Lite
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: Formula in conditional formatting

Waffle Chart with Football Icon-1
Charts and Visualization

Waffle chart with Football Icon in Excel

March 9, 2023March 9, 2023 PKComments Off on Waffle chart with Football Icon in Excel
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
Read More
Highlight selected Row and Column in Data
Excel Tips and Tricks

Highlight Row and Column of Active Cell in Data Automatically

March 2, 2023March 11, 2023 PKComments Off on Highlight Row and Column of Active Cell in Data Automatically
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
Read More
Multicolor data bar with REPT function
Charts and Visualization

Multi-color Data bar with REPT function

July 12, 2022July 12, 2022 PKComments Off on Multi-color Data bar with REPT function
In this article, we have created multi-color data bars in Excel cells using REPT function. We have used the conditional formatting to change the color based on certain criteria.  
Read More
Dynamic Calendar with Task List
Templates

Dynamic Calendar with Single formula

March 13, 2022May 10, 2022 PKComments Off on Dynamic Calendar with Single formula
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
Read More
Send WhatsApp and Email without VBA
Templates

Send WhatsApp and Email without VBA

January 17, 2022March 3, 2023 PKComments Off on Send WhatsApp and Email without VBA
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
Read More
Automated Attendance Sheet
Templates

Automated Attendance Sheet in Excel

December 6, 2020April 14, 2023 PKComments Off on Automated Attendance Sheet in Excel
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
Read More
Dynamic Data Bar
Charts and Visualization

Multicolor Filling Bars in Excel Cells Without using Chart

August 16, 2020August 16, 2020 PKComments Off on Multicolor Filling Bars in Excel Cells Without using Chart
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
Read More
Smart Data Entry Form with Minimum VBA
Templates VBA

Smart Data Entry form with minimum VBA

December 23, 2019December 23, 2019 PKComments Off on Smart Data Entry form with minimum VBA
In this article, we have a data entry form for candidate information with minimum VBA. We have used Excel formulas, conditional formatting and Form Controls. You can replicate this template
Read More
Daily Activity Tracker
Templates

Daily Activity Tracker in Excel

November 4, 2019November 4, 2019 PKComments Off on Daily Activity Tracker in Excel
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
Read More
Dynamic Conditional Formatting
Charts and Visualization

Dynamic Conditional Formatting in Excel

October 10, 2019October 10, 2019 PKComments Off on Dynamic Conditional Formatting in Excel
In this article, we have created Dynamic Conditional Formatting in Excel using Form Control Option Buttons. Conditional Formatting is changed in Heat Map (Color Scale), Data Bar and Traffic Lights
Read More

Posts navigation

1 2 Next
  • Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS – Lite
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy
This website uses cookies to improve your user experience, analyze site traffic and serve targeted ads in accordance with our Privacy Policy ACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT