New: NextGenTemplates Academy - video courses on Excel formulas with AI and Pivot Tables & dashboards. Early-bird: 20% off with code EARLYBIRD20 - first 20 orders only. See the courses →
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: Conditional Formatting

Conditional Formatting in a Line Chart in Excel: Green vs Red
Charts and Visualization

Conditional Formatting in a Line Chart in Excel: Green vs Red

November 3, 2018October 9, 2026 PK0
Conditional formatting in a line chart lets you colour each data point by a rule, just like conditional formatting colours cells. In this tutorial you build a month-wise Service Level
Read More
Highlight Top and Bottom Performer using Conditional Formatting
Excel Tips and Tricks

Highlight Top and Bottom Performer using Conditional Formatting

October 19, 2018October 9, 2026 PK0
You can highlight the top and bottom performer using conditional formatting in Excel so the best and the weakest employee light up the moment you pick an option from a
Read More
3D KPI Indicator in Excel: Red, Yellow, Green Traffic Light
Charts and Visualization

3D KPI Indicator in Excel: Red, Yellow, Green Traffic Light

September 30, 2018October 9, 2026 PK0
A 3D KPI indicator in Excel works like a traffic light for your metrics: three glossy balls in a grey frame, and only one lights up, red, yellow or green,
Read More
Excel Template with Protection and Validation (Free Download)
Excel Tips and Tricks

Excel Template with Protection and Validation (Free Download)

August 26, 2018October 9, 2026 PK0
An Excel template with protection and validation is the safest way to collect data from other people. You send one file to several team members, they fill it in, and
Read More
Conditional Formatting in Multiple Batteries Chart in Excel
Charts and Visualization

Conditional Formatting in Multiple Batteries Chart in Excel

July 30, 2018October 9, 2026 PK0
Conditional formatting in a multiple batteries chart lets one Excel chart show several KPI values as 3D battery cells that turn green when the target is met and red when
Read More
Traffic Lights in Excel: KPI Status Lights Without VBA
Charts and Visualization

Traffic Lights in Excel: KPI Status Lights Without VBA

July 24, 2018October 9, 2026 PK0
Traffic lights in Excel are one of the quickest ways to show KPI performance: red when a metric is below target, yellow when it is in the warning band and
Read More
Change% in Pivot Table: Month-over-Month Percentage Change
Excel Tips and Tricks

Change% in Pivot Table: Month-over-Month Percentage Change

July 6, 2018October 9, 2026 PK0
Showing the percentage change in a pivot table tells you at a glance whether this month is better or worse than the last one. Excel can do it without a
Read More
Project Plan in Excel
Charts and Visualization

Project Plan (Gantt Chart) in Excel

July 5, 2018February 18, 2025 PK0
Crafting a Project Plan (Gantt Chart) in Excel can initially appear to be an intimidating task. This is particularly true for those who are not well-versed with the nuances of
Read More
Charts and Visualization

Conditional Formatting in Stylish Doughnut Chart

June 23, 2018March 9, 2025 PK0
In my last post I have explained how to create stylish doughnut chart in Excel. I hope you has enjoyed that chart. Now in this article, you will learn how
Read More
Dynamic Calendar in Excel: Auto-Updating Month View (No VBA)
Templates

Dynamic Calendar in Excel: Auto-Updating Month View (No VBA)

April 7, 2018October 9, 2026 PK0
A dynamic calendar in Excel redraws itself the moment you pick a different month or year, so you never have to retype dates or shift cells around again. In this
Read More

Posts pagination

Previous 1 … 4 5
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • 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