Multi-color Data bar with REPT function in Excel

#MulicolorDatabar #ConditionalFormatting
Hello Friends,
In this video, you will learn how to create a multi-color Data bar with REPT function in Microsoft Excel. We have used the conditional formatting to change the color on the basis of certain criteria.
Download the practice file from the below link:
www.pk-anexcelexpert.com/mult...
See our Power BI videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
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...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

[@TroyJScott]

I love how you do excel Man. Thank you for the content

[@PKAnExcelExpert]

Most welcome

[@nsanch0181]

PK than you for the great video? I was familiar with the Rept, but never really got creative with the fonts. I tried Font Snap ITC and it made a nice looking ball type symbol. You have shown me some really cool tricks PK thank you.

[@PKAnExcelExpert]

Most welcome🙏

[@RashidAlharmoodi]

This was very useful - thank you!

[@PKAnExcelExpert]

Most welcome🙏

[@truewiking]

This is brilliant, Thank you very much 🙏

[@PKAnExcelExpert]

You're very welcome!

[@rajsahu1029]

No comments as beauty of data is the speciality of you. ❤️❤️

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Rajan-kk8nl]

Very very intersting, your every videos, thank you so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@diannanh]

Thank you so much for this!

[@PKAnExcelExpert]

You're so welcome!

[@katerina6495]

Beautiful, thank you PK

[@PKAnExcelExpert]

Most welcome

[@unnikrishnansanthosh]

great ideas, keep it up PK, thanks for sharing

[@PKAnExcelExpert]

Most welcome

[@temyraverdana6421]

Wow, an incredible trick. Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@teoxengineer]

So many thanks for this good presentation without using chart techniques 👍 I’m waiting for this type of interactive tutorials

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@VisuLytics]

Very helpful video PK. Thanks

[@PKAnExcelExpert]

Most welcome

[@nadermounir8228]

Nice video and very informative 👍 Thank u PK

[@PKAnExcelExpert]

Most welcome

[@sumardjo]

Thanks for your knowledge for file sample is very good to practice learn is very good thanks

[@PKAnExcelExpert]

Most welcome

[@jmathew6988]

Wow! Ingenious hack there. Solved my problem

[@PKAnExcelExpert]

Thanks

[@mohamedabo-ewisha6243]

Thanks for your knowledge💟💟💟

[@cgl4572]

Thank you so much 😊

[@PKAnExcelExpert]

Most welcome

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@PKAnExcelExpert]

Most welcome

[@jgun0075]

Awesome 👍😎

[@PKAnExcelExpert]

Thanks🙏

[@ICTNuggets]

Great video PK...thanks for uploading. In the future, can you please consider making a leave management system using SharePoint List, Power Apps, and Power Automate? Many thanks

[@PKAnExcelExpert]

We will try

[@gandhiviji]

Very use full method to make chart, Amzed me

[@PKAnExcelExpert]

Thanks🙏

[@Mu00lia]

Awosome

[@PKAnExcelExpert]

Thanks🙏

[@arturogallobalma4621]

You don't need to enter formulas, but in cell C2 enter =B2 drag up to C12, then select the range C2:C12, then Home --> Conditional Formatting --> Data Bars --> Solid Color and the chart is done.

[@batir8713]

Yep

[@mayankgupta7172]

How to separate data bar and datapoint in same cell

[@sunriseankuram1362]

Instead of PIPPING OR Zero can we keep image..ex: bottle

[@user-uq1bh7ho8b]

حلووووو

[@PKAnExcelExpert]

شكرًا

[@seendesign8795]

why I don't find this font in microsoft excel online?

[@seleskaviyag6377]

How to copy this chart to powerpoint?

[@fandulearning3685]

How did you put that pipeline symbol in excel

[@PKAnExcelExpert]

To insert the pipeline symbol in Excel, simply press the Shift key and the backslash () key simultaneously. This will result in the appearance of the pipeline symbol (|) in the desired cell. Give it a try!

[@syedasad7681]

What pipe line?

[@fakosentle1655]

👊

[@PKAnExcelExpert]

Thanks🙏

[@mayankgupta7172]

Which font is this

[@mayankgupta7172]

Playbull

[@Aka-293]

You go way too fast thru your step by step even if I replay the video multiple times. It would help if you had text on the side