Quality Check List in Excel || Use of Conditional Formatting || Use of Custom Formatting

#QualityCheckList #UsefulExcelTemplate #Conditionalformatting
Hello Friends,
In this video you will learn how to create a beautiful Quality check list in Excel. We have used Conditional formatting and Custom Formatting to create this. No VBA has been used.
Download this excel template from below given link:
www.pk-anexcelexpert.com/qual...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...

[@akakarun8]

I made and deployed the same Quality checklist in my work. Everybody has appreciated by looking this eye catching checklist. Thanks PK.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@poderdeexcel7428]

PK YOU ARE THE MAXIMUM, THANKS FOR EVERYTHING, I HOPE TO CONTINUE TO KNOW YOUR CREATIONS WITH DASHBOARD, THANKS FROM HEART.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tokevin3026]

Love the video so much! That’s clean and perfect.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@CEngrAries]

Thank you PK! This is awesome! This is better than checkbox which slows my Excel Checklist with 10,000 cells. Thank you for the Tips!

[@PKAnExcelExpert]

Glad it was helpful!

[@luzjudithquispemamani7870]

Is better and easier than check list programing Thank you my friend

[@KRYSISJAG]

Thank you from New Zealand 🥳✌

[@MohAboAbdo]

Thank you very much for this great video and for this valuable information.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ikebana8185]

Always Thanks so much for your videos, they helped me a lot^^

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abdullatif-de2qf]

vai apne super hero . onek valo lagse apner sob video. dowa kori allha jaw apnake onek valo rakhe. allha haffej.

[@godsontc243]

I am really appreciated man to providing a such useful I don't understand why you are still underrated As a marketing designing team I would suggest you to make more colourful and graphics to ur video So the people can easily find your KZbin channel and it's helpful to grow out of your ❤️

[@pulse_sonic]

Hi PK you are great.. having excellent knowledge in Excel... We would like to have dashboard and data presentation graphs in single click.... Pls make video on this...

[@deepaliarora9114]

Great video, In my new role as quality assurance, It helped me to create a quality checklist of my own and my manager is impressed. Thank you for posting it.

[@PKAnExcelExpert]

Most welcome🙏

[@aliahizati9286]

Thank you so much! This video help me so much, I've been googling for half day to solve this but cannot find the answer 😮‍💨😮‍💨Great video, easy to understand 👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@FraIvan]

For me, you channel is revelation! Wish you millions and millions of subscribers!

[@KaizenDT]

very well explained, detailed, easy to understand. thank you Mr. PK.

[@PKAnExcelExpert]

Most welcome

[@KaizenDT]

@@PKAnExcelExpert I have a question. Suppose I have inserted Tick in a cell, then I want to leave the cell blank, what to do?

[@KamalSingh-yt5rr]

Just a great video !!! Enjoyed myself to learn something new thru this video. I've a question for you regarding drop down list. Suppose if I want to populate more than one item name in one particular cell using drop down...can you please help me out with this? It would be really helpful 🙏

[@axlwrosess]

Thanks PK,as always take care bud...

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@emmanueldegelis84]

BRAVO, MERCI.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@harishas9213]

Thank you so much for this video

[@mohamedfazil6032]

Thankyou for this. I've learnt something good today

[@PKAnExcelExpert]

Glad it was helpful!

[@mst3669]

Thank you very much...can u add a vedio about basic macro...(recording & writing)

[@luzjudithquispemamani7870]

Thank you for your video!!!

[@PKAnExcelExpert]

Thanks for watching

[@a11googlephoto75]

your the you are the genius mr. excel . keep good work

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@awinawina9740]

Tqsm.. may god bless you. Truly help me. 🎉

[@PKAnExcelExpert]

Thanks🙏

[@obertdiz]

GRACIAS MUY BUENO

[@royeden1084]

Thanks a lot...great video....I have one question....If on certain dates we do not do QC so we will enter NA ...how do we ensure that does not impact the overall score of the month..?

[@user-nu5qt7sf3b]

It was very interesting and great help to make my own test list

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@iwanjirkuw8596]

Excellent! THANKS!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@vlogsbyfaisal7622]

Very helpfull video Thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@e.b.1406]

Thank you! Very helpful.

[@PKAnExcelExpert]

Most welcome

[@hazemali382]

great Mr thanks very much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AnithaMogle-qw2gs]

I really appreciate your help it's really good 👍

[@PKAnExcelExpert]

Glad to hear that

[@donnashields2976]

Great video I discovered this week. I have a question if I can create a third icon. I'm building a report to identify three products or in my case type.

[@Mohammedahmed-mx8pe]

Best video in KZbin 💚💚

[@PKAnExcelExpert]

Thanks a lot🙏

[@TheMuslimLearner]

Thank You So much... May Allah have mercy on you

[@PKAnExcelExpert]

Thanks for your blessings

[@hanalei412002]

Thank you for this, how do I make it a check? I don't want a drop down box. Great video thank you

[@shahidabbasi7126]

Informative and useful

[@PKAnExcelExpert]

Glad you think so!

[@sonalimukherjee8905]

It was very helpful thank u😁

[@PKAnExcelExpert]

Most welcome

[@vishwasfaye699]

PK It is very good video.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Saatt79]

Good one Sir 👏👏👏👏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@yaghoubnasirzadeh2651]

Very good!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ovskihouse5270]

Thanks

[@PKAnExcelExpert]

Most welcome

[@apn6824]

Today I learned a new technique even though having lots of exp in excel...Thank you so much and keep this ball rolling in the coming days. And if we have some doubts in excel during our work then how can we contact you ?

[@harlemjulian29]

instablaster.

[@sunilkumar-jl7uf]

well done bro should we have some more tricks on conditional formatting and pivot table.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gudipatisaideep5030]

Excellent video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@youngdumbyoungdumb]

hi thanks for a very informative video, is there any way we hide or delete the pass or fail support cells you created under I Colum ?

[@bharatkhokhani1444]

You can highlight those cell with white colour as it will be invisible 😂

[@sedatelbas2304]

Thank you

[@PKAnExcelExpert]

Thanks for watching

[@reginaakutekha9299]

Thank you soooo much

[@PKAnExcelExpert]

Most welcome🙏

[@gelizaaquino5816]

Thanks for this

[@PKAnExcelExpert]

My pleasure!

[@CCAFO]

Great!

[@PKAnExcelExpert]

Thanks🙏

[@tarun_k_shorts]

thnk sr ji

[@PKAnExcelExpert]

Thanks for watching

[@AkshayKanthY]

hey, what if the each product have different values like product one has 20 and product 2 has 30 and product 3 has 40 points? how is the average calculated for different product values?

[@ashithcalicut]

bro is it possible to make like double click will change between pass or fail

[@jibinjohn8569]

Thnku sir

[@suryar2898]

Very helpfull

[@PKAnExcelExpert]

Glad you think so!

[@sirikondavinay9921]

Superb sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@xlpointacademy5127]

Super Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@darshanpilankar4940]

Make for a study - inventory management sheet for production

[@PKAnExcelExpert]

I will definitely try to make such video very soon

[@wasimsaifi7684]

I am using 3 words instead of 2 words as Yes or No, but I am not getting same result. If I am using "Yes";"No";"Tentative" but the output is Tentative Yes and Yes not showing the No. Can you please help me?

[@lemaggedi]

IT is a real great video! Thank you so much!! I just have a question. When i need to have 3 options (completed, in progress, not started) instead of 2 (pass, fail). Which is the formula i have to enter instead of "pass";; "fail"?

[@PKAnExcelExpert]

You can see our below video: kzbin.info/www/bejne/mqnQeGh4h6-ajLM

[@lemaggedi]

I just watched the video but in each cell when i want to make selection of the List, shows the symbols. I would like to select from text list (completed, in progress, not started) and then to appear the icon. Like in this video. Could you please help me?

[@yapptze5141]

How can I from this data to extract product vs "pass" dates

[@shaukatsamad2510]

Great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@saiidmoussaif4076]

I did the same I just added 6 products instead of just 4 but the percentage shows 300% instead of just 100% how can I fix that please. and thank you for yoru simple yet great tutorial

[@pulse_sonic]

If we have doubt in our work how could we able to get you in touch

[@kebedewedajo8346]

gooood

[@PKAnExcelExpert]

Thanks🙏

[@planetenterprises5620]

Hi How to protect cells from modifying/deleting after entered

[@aakashchoudary8501]

How I can add N/A options in this list

[@kmanoj392]

Very good

[@PKAnExcelExpert]

Thanks

[@sonatahd9877]

very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mohamedsiciid708]

if i press number 6 it says correct only it makes fail when press 0 so how to make only number one is correct and other number is in correct . thank

[@raghuv7114]

Nice ji

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mdamirul8503]

Nice

[@PKAnExcelExpert]

Thanks🙏

[@Bala-nc4sn]

nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@albertmasuhay5845]

HELP ME HOW TO CREATE THIS IN GOOGLE SHEET

[@ayeshabondogji4737]

Can we do the same procedure with many input like 1 refers to very low 2low and so on until 5 very high

[@ayeshabondogji4737]

??

[@PKAnExcelExpert]

Yes, we can do. Will create another video on this

[@ayeshabondogji4737]

@@PKAnExcelExpert thank you

[@Xyour_starX]

PK

[@wildanfahmi-bd6if]

can you use it without using data validation?

[@PKAnExcelExpert]

Please see below video. It may help you kzbin.info/www/bejne/jp-pdKGZhJmMn7M

[@markevananiel]

The problem I'm encountering is after you save it and open it. The conditional formatting is gone

[@AASHUTOSH_K_SATH]

Sir mere problem ka koi solution nahi hai Mere pass koi data hai jisme pivot table laga hua hai or filter ka option hai or mai ye chahta hu ki ye filter automatic change ho or uss filter data ka print ho or fir se filter change ho or print ho jaye Plz koi videos publish hai to link bhejiye plz Urgent

[@ElzaanVeldsman]

I love this but the quality column is the problem. I type in =IFERROR(AVERAGE(G5:AO5),"") and it keeps on giving me an error message.

[@sirikondavinay9921]

Give space in between inverted commas which are in end

[@amitgoswami3875]

Thanks

[@PKAnExcelExpert]

Thanks for watching