Progress Bar in Excel Cells using Conditional Formatting

[@Chuck-xl2ez]

Excellent video, clear explanation, and to the point - thank you much PK !

[@PKAnExcelExpert]

Most welcome

[@1981kamlesh]

Explained so simple way..Amazing Thanks

[@PKAnExcelExpert]

Most welcome

[@stevebaker187]

Yep - I concur - got me what I needed - much faster and simpler than other online help. Thank you!

[@J0YJiT]

Very informative tutorial PK. Thanks a lot

[@PKAnExcelExpert]

Most welcome🙏

[@SubashAntony]

Great.. Thankyou very much

[@PKAnExcelExpert]

Most welcome

[@PossibleTarget24]

Yes brother it is useful for me.....Thank so much, I really appreciate.....👏

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@darrenjohnson1889]

This was great! Thanks!

[@PKAnExcelExpert]

Most welcome🙏

[@fatkulkhoir4397]

Great video, I like that you go directly to the point, thank you!

[@PKAnExcelExpert]

Glad it was helpful!

[@handychandra6238]

Thank's a lot. From Indonesia

[@PKAnExcelExpert]

Most welcome

[@anthonywashington2885]

You are legendary

[@PKAnExcelExpert]

Thanks a lot🙏

[@abcd7054]

Super Thanks. Very useful.

[@CyborgHyperdrive]

Perfect, thank you very much

[@PKAnExcelExpert]

You are welcome!

[@vb_Sivvv]

thank you man, this is awesome!

[@PKAnExcelExpert]

Most welcome🙏

[@deannalaw9922]

I have been trying to figure this out all day , this video was super helpful and to the point! Well Done !

[@andriefirmana]

Thank You from Indonesia, it is very helpfull

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@crallo_phades]

Beautiful and easy to follow… keep it up

[@PKAnExcelExpert]

Thanks a lot 😊

[@mausieur]

Thank you! this is exactly what I was looking for

[@PKAnExcelExpert]

Glad it was helpful!

[@MikeCarey101]

brilliant and simple- thank you

[@PKAnExcelExpert]

Most welcome🙏

[@namdeosanskar7900]

Thankyou so much.

[@Angela-zu5bk]

You're a blessing. Thank you

[@PKAnExcelExpert]

Most welcome🙏

[@mahdialifanaan3179]

Thanks PK for the usual support and sharing your experience and knowledge.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lindawilliams9736]

WOW!!! What a great feature! Thanks so much!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@polloNOOBkiter]

Awesome tutorial! Thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@thabisotembe5916]

Thank you, this is very helpful

[@PKAnExcelExpert]

Thanks🙏

[@ingmancera]

Great explanation, thanks a lot PK!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@assmalamamri8733]

Thanks, that was helpful

[@PKAnExcelExpert]

Glad to hear it!

[@tasneemrangwala9036]

Amazing videos - I am a Analyst and I have learnt alot fro your videos eveytine

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tasneemrangwala9036]

PK: An Excel Expert can u do a hr dashboard, productwise sales dashboard and attrition analysis

[@SuccessMindset2180]

1. Make a representation of dynamic progression: brand, track (injections and human health), prospect (procedures and health), adaptability (alkaloids and health) 2. Health's Triptych: injections and human health, procedures and health, alkaloids and health 3. Formating cells can be useful

[@altheaartieda4205]

Thanks for sharing sir.God bless😇

[@PKAnExcelExpert]

Most welcome🙏

[@sokhachib1249]

Thanks for your perfect explanation

[@PKAnExcelExpert]

Glad it was helpful!

[@MrVerdomme]

exactly what i needed, thanks man!

[@PKAnExcelExpert]

Glad I could help!

[@rajatjaiswal8808]

Nicely explained concept. Was very useful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@PinoyAbroader]

thank you! this help me a lot on making my progress report love it

[@PKAnExcelExpert]

Glad it helped!

[@Mishin108]

Thank you, this was very helpful and straight to the point.

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@swapnalpatil2840]

Superb video, thank you so much

[@PKAnExcelExpert]

Most welcome

[@ihohanna]

Thank you so much! very well explained !! :)

[@PKAnExcelExpert]

You are welcome!

[@AshishhP1209]

Thank you 🙏

[@PKAnExcelExpert]

Most welcome

[@mojoturner5292]

Is it possible to fill the cell from another cell? ie. I have data and would like for it to automatically update the percentage across the year. Great video.

[@nickdelaney2470]

Yes, you can conditional format cells using data from a separate cell

[@Robert723]

Thank you!!!!!!!!!!!!!!!!!!!!

[@PKAnExcelExpert]

Most welcome

[@jeanjuliano887]

Thankio to show us your Professional simple Methodes and i am really really impress to learns to behave my Currier in the work place. Jj

[@picklepirate]

Thanks for the help!

[@PKAnExcelExpert]

Most welcome

[@shinebrightdarling]

SO SO helpful, thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AnoopJogi]

Thanks for this tip. Can we have an additional conditional formatting on the bar, e.g., if below 25% then color is red, between 26% and 75% color yellow and above 75% color is green?

[@antnfs]

Maybe try combining the data bar option with the ‘formatting based on formula’ option if excel allows it. That way you could use IF functions to apply different colours to different data ranges, but I have a suspicion data bars can’t be applied to formulae.

[@cricketkajunoon]

Yes, you can probably do that by adding additional conditions. I’ve done it with numbers not the bars. You can change the color of the text based on the percentage you’ve selected

[@Musafir575]

Thank you so much. It was really helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@GeorgeAJululian]

thank you it was very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AbhishekMishra-cr1tz]

Very useful video thanks sir

[@PKAnExcelExpert]

Most welcome

[@paulprice254]

Just what I was looking for, excellent!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@svigojski]

Thank you. I was looking for that.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vimalpanagoda5796]

Thank you so much

[@PKAnExcelExpert]

You're most welcome

[@加藤パウリナ]

Thank You soo much!

[@PKAnExcelExpert]

Most welcome🙏

[@hey38hey99]

Many thanks for sharing

[@PKAnExcelExpert]

My pleasure

[@danqueirozdl]

Thank you!!

[@PKAnExcelExpert]

You're welcome!

[@KineticSprinter]

Great video. Thank you.

[@PKAnExcelExpert]

Glad you liked it!

[@athchuthavamsikrishna]

Hi sir good information, how to paste in an outlook with a data bar needed in table format not in pic format plz help me

[@DynamicGenesis]

Thank you, excellent video short and to the point.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jeffreybernal6032]

Thanks ☺️

[@PKAnExcelExpert]

Most welcome

[@ericbauer]

Well done

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Melodymerijaan]

thnx sir

[@PKAnExcelExpert]

Most welcome

[@carlagarcia-fernandez1741]

I love this! How can I remove the dropdown arrow. It is visible when I printed it.

[@liambrien7200]

Such a great video. Thank you! This was exactly what I was looking for and you explained it perfectly.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@hernanperez912]

Thanks

[@PKAnExcelExpert]

Most welcome

[@brolysmash9333]

Dude great video, you have a subscriber now :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@brolysmash9333]

Totally dude this can keep you motivated.

[@earlybirdie9532]

Yes very helpful! Thanks! Now subscribed to your informativr channel. Thanks a mil!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ettaqyelmakky9927]

thanks, you saved me!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MaryamGhorbanpour]

Thanks a lot. how can we copy this into Microsoft word ? I copied it as a picture into Microsoft Word. Can we copy it as an editable table in word?

[@stephanrodriguez6587]

Thanks homie!

[@PKAnExcelExpert]

Most welcome

[@amirsaiftaz]

Simple n useful, thanks PK ji

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@memoaa7467]

Great video, I like that you go directly to the point, thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ahmadesam4568]

thank you bro

[@PKAnExcelExpert]

Most welcome🙏

[@junedshaikh2964]

It really works. However, the bar is not coming as dynamic. is there a specific reason?

[@albanoteles4924]

EXcellent topic. Thanks .

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ka4696]

This is excellent, thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pandharinathjoshi6565]

Sir nice,, make one video for icons with different examples sir

[@hamednouri4574]

Thanks, that was useful for me

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kingofwake]

Very helpful thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@blrdls]

Thank you!!!!!!!!

[@PKAnExcelExpert]

Welcome

[@MohAboAbdo]

Thank you very much for this great video and for this extensive explanation, thank you very much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@cengineer8756]

Is there a way to plot only between percentages? For example, I need to plot only between 10%-90% leaving white spaces at both ends

[@PKAnExcelExpert]

Great suggestion! I will try to create a video on this topic.

[@success555]

Thanks for the video Partner.

[@PKAnExcelExpert]

Thanks for watching

[@artes900]

thank you

[@PKAnExcelExpert]

Most welcome

[@rafaelaandrevaras4662]

EXCELENTE, GRACIAS POR SU ENSEÑANZA

[@PKAnExcelExpert]

Gracias por sus valiosos comentarios

[@kevintaculao1409]

Thanks! This is really helpful! :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sameerh3111]

Thank you for showing progress chart in excel Can you show creating Progress Bar in Google Spreadsheet ?

[@rimantasdanilevicius6754]

Great tutorial. Short and very informative! Question if I have column with different values and I want to find max value of that column (it is simple), but how to implement that code in format there I need to right number, but I have the code? I hope that makes sense.

[@manjunathchandran7423]

Excellent Sir ! Thanks for the beauty.

[@PKAnExcelExpert]

Thanks for Thanks for your valuable

[@subhashghosh7172]

Short and effective. Thank you for such a great video

[@amitmerwar2381]

Thanks for the video! Made my life so much easier! 5*****

[@justwin2988]

Good Info, is there any way to mark border with color once its reverse from high, my point is suppose its Live number movement and one progress reach to 90 and return to 70 so in this case I need to know it was touch to 90 and now running at 70. So this reversal I can see through color image ?

[@iftekharraju318]

Excellent thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Tahirabbas-hj2gs]

Very useful. Can we make vertical bars?

[@kool4053]

Thanks it helped a lot. How to change the colors based on percentage?

[@rahulshewale9206]

Thanks sir , Could you please make video on speed up excel calculation

[@ManiKandan-fn2rq]

Sir, I Saw precious % data very good explain & easy Understands.Thank. Please one more request shit based work make in excel & Time of In punch & Out Punch in excel data available but Data how to do secrecate total time base .Can u help sir.thanks

[@MD_Jaini]

It should be based on the left side what you have given like progress, completed Based on that the percentage should be there

[@PKAnExcelExpert]

Please watch our other videos given below on this topic: kzbin.info/www/bejne/qXXdkoGpndGlm80 kzbin.info/www/bejne/q33NaXurmayMb7c

[@pandharinathjoshi6565]

Very nice sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kayepenafiel9183]

I REALLY NEED YOUR HELP! can you suggest an easy project based on concatenate?

[@NaturallyNishy]

This was very helpful. Thank you 😊

[@tienngotk]

Thank for nice video. Btw, could you tell me what app are you using to creat such videos?

[@unknown-kn4uf]

Thanks

[@PKAnExcelExpert]

Welcome

[@vijaypawar8523]

Hi can we have different color based on different status, if I change the status to progress color should be blue fill, if status is complete should be green

[@MrMosoani]

I just used your Daily Activities tracker and wanted to share it to my team. Now I’d like to have all their percentage finished for the day collected and use this progress bar so I can view all of my teams completion rate. How can I collect them all and show the team members individual progress bar?