• Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
  • VBA Course
  • Products
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • 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
    • PM Dashboard
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Power BI
  • About Us
  • Contact Us

PK: An Excel Expert

Online Excel Tutorials

Tag: Formula in conditional formatting

Automated Attendance Sheet
Templates

Automated Attendance Sheet in Excel

December 6, 2020December 6, 2020 PKComments Off on Automated Attendance Sheet in Excel
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
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
Daily Activity Tracker
Templates

Daily Activity Tracker in Excel

November 4, 2019November 4, 2019 PKComments Off on Daily Activity Tracker in Excel
Dynamic Conditional Formatting
Charts and Visualization

Dynamic Conditional Formatting in Excel

October 10, 2019October 10, 2019 PKComments Off on Dynamic Conditional Formatting in Excel
Advanced Condtional Formatting
Excel Tips and Tricks

Search Text from Specific or all columns in Excel

September 9, 2019September 9, 2019 PKComments Off on Search Text from Specific or all columns in Excel
Birthday Count
Excel Tips and Tricks

Highlight and get birthdays count from Date of Birth

July 8, 2019July 8, 2019 PKComments Off on Highlight and get birthdays count from Date of Birth
Highlight Unmatched Cells
Excel Tips and Tricks

Highlight Unmatched Cells using Conditional Formatting in Excel

April 22, 2019April 22, 2019 PKComments Off on Highlight Unmatched Cells using Conditional Formatting in Excel
Highlight Consecutive Duplicates
Excel Tips and Tricks

Highlight the Consecutive Duplicates in Excel using Conditional Formatting

April 22, 2019April 22, 2019 PKComments Off on Highlight the Consecutive Duplicates in Excel using Conditional Formatting
Highlight Top and Bottom Performer
Excel Tips and Tricks

Highlight Top and Bottom Performer using conditional formatting

October 19, 2018October 19, 2018 PK0

Top Categories

  • Charts and Visualization (102)
  • Dashboard (5)
  • Excel Tips and Tricks (35)
  • Power BI (12)
  • Power Pivot (11)
  • Power Point Visualization (4)
  • Predictive Analytics (3)
  • Templates (31)
  • VBA (61)

Read More about..

  • Advanced Excel
  • VBA Course
  • Dashboard
  • Chart and Visualization
  • VBA Tips
  • Excel Tips and Trics
  • Our Excel Products
  • About US
  • Contact Us

 

Subscribe to our Newsletter



Download Free Dashboards

  • Project Management Dashboard
  • Zonal Dashboard
  • Sales Dashboard
  • Outbound Dashboard
  • A Quick Dashboard
  • C-SAT Dashboard
  • Performance Dashboard
  • Process Dashboard
  • Incentive Dashboard

Recent Posts

  • Annual Leave Tracker with Daily/Monthly View in Excel
  • Stylish Attendance Tracker with Symbols
  • Transport Cost Optimization Using Solver in Excel
  • What-If Analysis (Goal Seek, Scenario Manager and Data Table) in Excel
  • Dynamic Pivot Table with Multiple Tables using Power Query
  • Vertical and Circular Bullet Chart in Excel
  • Inventory Management Template for Store
  • 10 Pro Tips for Excel Charts
  • Dynamic Hourly Project Planner (Gantt Chart)
  • Price Fetching Tool from Amazon and Flipkart
Copyright © 2018 PK-AnExcelExpert.com - Privacy Policy