Multicolor Filling Bars in Excel Cells Without using Chart

[@nsanch0181]

Thank you for the trick PK. Once again you showed me a new and better way of doing things. Thank you!

[@StephaneR0sa]

It's very smart to use backward white to have at the same time a progress bar and a value based color ! Thanks :-)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@philipberesford2648]

Brilliant job. All the detail needed and still concise.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@wahidovich2021]

God bless you PK, I've been looking for this one exactly the one as in "Service Level" data sheet, I just didn't know how to phrase my question :( Thanks a lot man!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@saramurgia8367]

really a very good tutorial. well made, clear and not boring. bravo!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@rossybink]

Any Service Level Manager would love this. Thanks, great work! 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@LudwigSpiegel]

Thank you for Sharing! Just what I was looking for!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rajsahu1029]

Nice. A good revision of conditional formate also done

[@snowwhite2146]

Thank you for this excellent video!

[@PKAnExcelExpert]

You're very welcome!

[@amal2503]

Nice and effective! Thanks Pk

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shilandatstewart]

Exceptional tutorial. Exactly what I needed

[@PKAnExcelExpert]

Thank you very much!

[@mavado5046]

Wow you are very clever!

[@PKAnExcelExpert]

Thanks🙏

[@dhanu502]

Great content and excellent explanation PK Sir. Thank you very much.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@abdusshakur2878]

very nice helpful video Thank you

[@PKAnExcelExpert]

Most welcome

[@rajeshchoudhary2520]

Thank You Sir....Very Nice Video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@albertozamora7099]

Thank you this was very helpful

[@PKAnExcelExpert]

Glad it was helpful!

[@apn6824]

Very good info PK..But I have told you already that you have to zoom in while typing or selecting options so that viewers can see it clearly what you're doing. It will easy to understand & practiced clearly

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will take care of this in upcoming videos

[@jaydeeplimbad90]

Thank you Sir... For conditional formatting process....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@senthooranaccel9529]

You are a star !

[@PKAnExcelExpert]

Thanks a lot.

[@Luciano_mp]

Awesome, good, thanks.👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abdelhadia8712]

Thanks a lot Professor

[@pandharinathjoshi6565]

Wonderful sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vanessabbrooks698]

Amazing Thank you

[@PKAnExcelExpert]

Most welcome🙏

[@GeorgeAJululian]

thank you extremely helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ranarizwanahmed]

Very good tutorial

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@janezklun]

Nice approach, thank you for sharing, Best regards

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nitinsingh.2107]

Great work!

[@PKAnExcelExpert]

Thank you! Cheers!

[@qualityrelaxationmusic9284]

Great. Please start on python and pandas library.. to atomate the excel report. Really we need it. And your teaching skill is awsome. Please please please start your videos on python

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will try.

[@gov_laxvlogs3982]

Thanks 👍

[@PKAnExcelExpert]

Most welcome🙏

[@iwankurniawan9666]

Thank you so much my GURU ..

[@PKAnExcelExpert]

Most welcome

[@deepaknagar5697]

Wow, amazing , thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@JeffersonAMontoya]

Excelente maestro

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kunio4143]

Thanks for sharing, very useful:)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@razzaqabdur1761]

fantastic sir, Thanks

[@pawansharma-wo3xh]

Very good pk... Please also start tutorial on power BI and DAX

[@PKAnExcelExpert]

Thanks for your valuable feedback. Will upload soon

[@jewelmia2126]

Excellent, thank you.

[@PKAnExcelExpert]

You are welcome!

[@nonoobott8602]

Your videos are always very insightful. Thanks for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Alibabachalise]

Sir thank you for the Lesson and permission to download practice file. Appreciated very much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Lovesv29]

Good pk

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jackmonsel8987]

Good Job, I just wished there was a way to get rid of annoying colored border around the white bars.

[@pandharinathjoshi6565]

You are great sir., sir one question you can write comment sir... how you think to do excellent idea pls

[@drislam1231]

thank you very much really beneficial, could we remove the remaining borders of cell fill color because bar is slightly smaller than cell hieght making part of cell background appears

[@PKAnExcelExpert]

Yes we can

[@kyleparadise9821]

Great content; question. With the first example, can you make the remaining of the data bar a different color? For instance if it is 75% on time, it will be filled green 3/4 of the cell. Can you color the remaining 1/4 of the cell a different color?

[@shubhamverma2800]

Dear sir I requested to you that please make a video about the power bi. I want want to learn from your video.

[@mohankumar-lc3pm]

Thank you

[@PKAnExcelExpert]

Welcome

[@Cristiano_Ronaldo_28_17_7]

Wow nice sir i understood i will use it but sire can you teach us forecasting manpower calculation scheduling WFM part please sir please

[@duikmans]

What would you do if you also have to include negative percentages in your data bar?

[@krissyb884]

This doesn’t work for me. The white bar fills the cell based off the %. For example, if the cell was 30%, the white bar would fill the cell up 30% of the way instead of 70%. Any fixes for this issue ?

[@meganharris8651]

Same for me i dont understand please help!

[@GizmoGamesE33]

@@krissyb884 same, need assistance

[@GizmoGamesE33]

Figured out a fix. Relatively simple. Inclue a "=1-(insert value formula)" With this though you cannot show the value on the data bar, as it will be the opposite of the actual value you are trying to represent. But this will make the white data bar start at 100% filling the cell, and as your progress value grows, the subtraction function will make the data bar go down appropriately.

[@excellearners7976]

thnx

[@PKAnExcelExpert]

Most welcome

[@shivannahr780]

ms access form data entry tutorial Start sir very interested your teaching thanks sir

[@PKAnExcelExpert]

Please watch the below given videos- kzbin.info/www/bejne/aoi7q4OIhMidgqc kzbin.info/www/bejne/l4qtkqd6nrOmrbM

[@alializadeh8195]

Thanx

[@PKAnExcelExpert]

Welcome

[@pankaj3648]

Sir , insentive sheet excel की बनानी है ।

[@sanand222]

V nice video... V useful...can u create a dashboard sla scorecard based on the requirements like ABN rate, ASA, FCR, CSAT AND OTHER PARAMETERS

[@PKAnExcelExpert]

Please refer the below given playlist. kzbin.info/aero/PLbDvAYjpWJ7CpupRYMRkXSN0L92t7nUuF

[@sumank2190]

Sir...How to Use....Pk's Utility Version 1.0 & 2.0 in Win-7,MS Off-2010....am using MS Off 2010...am Add in version 1.0..still it is not working in my system...??? Same for 2.0 also....Pls....give me Solutions for those problems..???

[@effatmehmood6654]

I have taken single data and have highlighted with colors, but when i add data bars .. it disappears 100 percent and showing red bar bigger..

[@vogueasr2363]

❤

[@PKAnExcelExpert]

Thanks 🙏

[@krishnaveni6384]

Can anyone help with a macro how to write formula based on column header and fill down till last used row.. Specially when formulas are written in separate sheet say sheet1 as all the formulas and sheet name( Col a = headers, col b= formula) Sheet 2 has headers in row 1, in horizontal, macro should look sheet1 and list the formula in sheet 2 once the headers matches and has to fill till last used row Unsure how to do that

[@jazyhappy5018]

I want to show progress with status only. Like if I select completed then bar should show 100% if in progress then it should be 50% and pending should be 25% not started 0%

[@agungrahmadiutama2178]

👍👍👍👍👍

[@PKAnExcelExpert]

Thanks

[@hijodeGaladriel]

Si si teclado está en español y no les funciona con And, deben poner Y

[@BMAA_off]

Hello

[@moskitowilliam4398]

PK, let me know if u need anything from Ghana God bless you

[@luckyverma2357]

Hello Sir i would like to get in touch with for an assignment, i have also mailed you and messaged you in telegram, waiting for your kind response

[@andreloo3024]

Too slow, I fell asleep.

[@luckyverma2357]

?????

[@mahirbadanagki]

Thank you

[@PKAnExcelExpert]

Most welcome

[@luckyverma2357]

?????