Formula in conditional formatting Archives - PK: An Excel Expert

Multicolor data bar with REPT function

Charts and Visualization

Multi-color Data bar with REPT function

July 12, 2022July 12, 2022 PKComments Off

Dynamic Calendar with Task List

Templates

Dynamic Calendar with Single formula

March 13, 2022May 10, 2022 PKComments Off

Send WhatsApp and Email without VBA

Templates

Send WhatsApp and Email without VBA

January 17, 2022January 17, 2022 PKComments Off

Automated Attendance Sheet

Templates

Automated Attendance Sheet in Excel

December 6, 2020December 6, 2020 PKComments Off

Dynamic Data Bar

Charts and Visualization

Multicolor Filling Bars in Excel Cells Without using Chart

August 16, 2020August 16, 2020 PKComments Off

Smart Data Entry Form with Minimum VBA

Templates VBA

Smart Data Entry form with minimum VBA

December 23, 2019December 23, 2019 PKComments Off

Daily Activity Tracker

Templates

Daily Activity Tracker in Excel

November 4, 2019November 4, 2019 PKComments Off

Dynamic Conditional Formatting

Charts and Visualization

Dynamic Conditional Formatting in Excel

October 10, 2019October 10, 2019 PKComments Off

Advanced Condtional Formatting

Excel Tips and Tricks

Search Text from Specific or all columns in Excel

September 9, 2019September 9, 2019 PKComments Off

Birthday Count

Excel Tips and Tricks

Highlight and get birthdays count from Date of Birth

July 8, 2019July 8, 2019 PKComments Off