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

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

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

[@Curic-Ivan]

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

[@Mohammedahmed-mx8pe]

Best video in KZbin 💚💚

[@PKAnExcelExpert]

Thanks a lot🙏

[@Thatdeeptalk]

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🙏

[@abdullatif-de2qf]

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

[@awinawina9740]

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

[@PKAnExcelExpert]

Thanks🙏

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

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

[@AnithaMogle-qw2gs]

I really appreciate your help it's really good 👍

[@PKAnExcelExpert]

Glad to hear that

[@mohamedfazil6032]

Thankyou for this. I've learnt something good today

[@PKAnExcelExpert]

Glad it was helpful!

[@KRYSISJAG]

Thank you from New Zealand 🥳✌

[@a11googlephoto75]

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

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

[@tokevin3026]

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

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

[@sonalimukherjee8905]

It was very helpful thank u😁

[@PKAnExcelExpert]

Most welcome

[@vishwasfaye699]

PK It is very good video.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vlogsbyfaisal7622]

Very helpfull video Thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@iwanjirkuw8596]

Excellent! THANKS!

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

[@MohAboAbdo]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TheMuslimLearner]

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

[@PKAnExcelExpert]

Thanks for your blessings

[@hazemali382]

great Mr thanks very much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@e.b.1406]

Thank you! Very helpful.

[@PKAnExcelExpert]

Most welcome

[@axlwrosess]

Thanks PK,as always take care bud...

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

[@gudipatisaideep5030]

Excellent video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Saatt79]

Good one Sir 👏👏👏👏

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@luzjudithquispemamani7870]

Thank you for your video!!!

[@PKAnExcelExpert]

Thanks for watching

[@sirikondavinay9921]

Superb sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@harishas9213]

Thank you so much for this video

[@yaghoubnasirzadeh2651]

Very good!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@CCAFO]

Great!

[@PKAnExcelExpert]

Thanks🙏

[@suryar2898]

Very helpfull

[@PKAnExcelExpert]

Glad you think so!

[@emmanueldegelis84]

BRAVO, MERCI.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gelizaaquino5816]

Thanks for this

[@PKAnExcelExpert]

My pleasure!

[@reginaakutekha9299]

Thank you soooo much

[@PKAnExcelExpert]

Most welcome🙏

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

[@planetenterprises5620]

Hi How to protect cells from modifying/deleting after entered

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

[@sunilkumar-jl7uf]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@xlpointacademy5127]

Super Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

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

[@ashithcalicut]

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

[@kmanoj392]

Very good

[@PKAnExcelExpert]

Thanks

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

[@hanalei412002]

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

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

[@mst3669]

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

[@aakashchoudary8501]

How I can add N/A options in this list

[@darshanpilankar4940]

Make for a study - inventory management sheet for production

[@PKAnExcelExpert]

I will definitely try to make such video very soon

[@raghuv7114]

Nice ji

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shaukatsamad2510]

Great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@obertdiz]

GRACIAS MUY BUENO

[@kebedewedajo24]

gooood

[@PKAnExcelExpert]

Thanks🙏

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

[@albertmasuhay5845]

HELP ME HOW TO CREATE THIS IN GOOGLE SHEET

[@tarun_k_shorts]

thnk sr ji

[@PKAnExcelExpert]

Thanks for watching

[@sedatelbas2304]

Thank you

[@PKAnExcelExpert]

Thanks for watching

[@amitgoswami3875]

Thanks

[@PKAnExcelExpert]

Thanks for watching

[@PiXpilot_Shridhar]

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

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

[@yapptze5141]

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

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

[@mdamirul8503]

Nice

[@PKAnExcelExpert]

Thanks🙏

[@sonatahd9877]

very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@Bala-nc4sn]

nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@markevananiel]

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

[@Xyour_starX]

PK

[@ovskihouse5271]

Thanks

[@PKAnExcelExpert]

Most welcome

[@jibinjohn8569]

Thnku sir