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:

See our Power BI videos:


Learn and download our interactive Excel dashboards free of cost-

Download the Free Project Management Dashboard

Download the Calendar Control in VBA from below link

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

LinkedIn:

Instagram:

Visit our Amazon Store

[rajsahu]

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

[TroyJScott]

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

[Rajan-kknl]

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

[nsanch]

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.

[arturogallobalma]

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.

[jmathew]

Wow! Ingenious hack there. Solved my problem

[sumardjo]

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

thanks

[truewiking]

This is brilliant, Thank you very much 🙏

[teoxengineer]

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

[unnikrishnansanthosh]

great ideas, keep it up PK, thanks for sharing

[nadermounir]

Nice video and very informative 👍 Thank u PK

[diannanh]

Thank you so much for this! <3

❤

[gandhiviji]

Very use full method to make chart, Amzed me

[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

[seendesign]

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

[mayankgupta]

How to separate data bar and datapoint in same cell

[sunriseankuram]

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

[fandulearning]

How did you put that pipeline symbol in excel

[Aka-]

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