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

[@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

[@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!

[@abdullatif-de2qf]

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

[@ovskihouse5270]

Thanks

[@PKAnExcelExpert]

Most welcome

[@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?

[@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🙏

[@MohammedMukarramHussain-m7b]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@awinawina9740]

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

[@PKAnExcelExpert]

Thanks🙏

[@Curic-Ivan]

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

[@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🙏

[@tokevin3026]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Mohammedahmed-mx8pe]

Best video in TH-cam 💚💚

[@PKAnExcelExpert]

Thanks a lot🙏

[@KRYSISJAG]

Thank you from New Zealand 🥳✌

[@mohamedfazil6032]

Thankyou for this. I've learnt something good today

[@PKAnExcelExpert]

Glad it was helpful!

[@AnithaMogle-qw2gs]

I really appreciate your help it's really good 👍

[@PKAnExcelExpert]

Glad to hear that

[@a11googlephoto75]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@luzjudithquispemamani7870]

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

[@shahidabbasi7126]

Informative and useful

[@PKAnExcelExpert]

Glad you think so!

[@vlogsbyfaisal7622]

Very helpfull video Thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MohAboAbdo]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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 TH-cam channel and it's helpful to grow out of your ❤️

[@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.

[@ikebana8185]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@iwanjirkuw8596]

Excellent! THANKS!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@vishwasfaye699]

PK It is very good video.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sonalimukherjee8905]

It was very helpful thank u😁

[@PKAnExcelExpert]

Most welcome

[@reginaakutekha9299]

Thank you soooo much

[@PKAnExcelExpert]

Most welcome🙏

[@TheMuslimLearner]

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

[@PKAnExcelExpert]

Thanks for your blessings

[@e.b.1406]

Thank you! Very helpful.

[@PKAnExcelExpert]

Most welcome

[@hazemali382]

great Mr thanks very much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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:
th-cam.com/video/dxmG5BRJgVQ/w-d-xo.html

[@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?

[@suryar2898]

Very helpfull

[@PKAnExcelExpert]

Glad you think so!

[@axlwrosess]

Thanks PK,as always take care bud...

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@gudipatisaideep5030]

Excellent video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@harishas9213]

Thank you so much for this video

[@gelizaaquino5816]

Thanks for this

[@PKAnExcelExpert]

My pleasure!

[@CCAFO]

Great!

[@PKAnExcelExpert]

Thanks🙏

[@luzjudithquispemamani7870]

Thank you for your video!!!

[@PKAnExcelExpert]

Thanks for watching

[@sirikondavinay9921]

Superb sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jibinjohn8569]

Thnku sir

[@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 🙏

[@yaghoubnasirzadeh2651]

Very good!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@emmanueldegelis84]

BRAVO, MERCI.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sunilkumar-jl7uf]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@PiXpilot-Shridhar]

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...

[@hanalei412002]

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

[@kmanoj392]

Very good

[@PKAnExcelExpert]

Thanks

[@Saatt79]

Good one Sir 👏👏👏👏

[@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

[@mst3669]

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

[@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..?

[@obertdiz]

GRACIAS MUY BUENO

[@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?

[@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.

[@xlpointacademy5127]

Super Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shaukatsamad2510]

Great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kebedewedajo24]

gooood

[@PKAnExcelExpert]

Thanks🙏

[@ashithcalicut]

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

[@sedatelbas2304]

Thank you

[@PKAnExcelExpert]

Thanks for watching

[@darshanpilankar4940]

Make for a study - inventory management sheet for production

[@PKAnExcelExpert]

I will definitely try to make such video very soon

[@mdamirul8503]

Nice

[@PKAnExcelExpert]

Thanks🙏

[@sonatahd9877]

very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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

[@wildanfahmi-bd6if]

can you use it without using data validation?

[@PKAnExcelExpert]

Please see below video. It may help you
th-cam.com/video/XnFCncO4YiQ/w-d-xo.html

[@planetenterprises5620]

Hi
How to protect cells from modifying/deleting after entered

[@raghuv7114]

Nice ji

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@aakashchoudary8501]

How I can add N/A options in this list

[@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?

[@Bala-nc4sn]

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

[@PiXpilot-Shridhar]

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

[@markevananiel]

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

[@yapptze5141]

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

[@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

[@albertmasuhay5845]

HELP ME HOW TO CREATE THIS IN GOOGLE SHEET

[@Xyour_starX]

PK

[@tarun_k_shorts]

thnk sr ji

[@PKAnExcelExpert]

Thanks for watching

[@amitgoswami3875]

Thanks

[@PKAnExcelExpert]

Thanks for watching