Excel conditional formatting and formulas based on color | Excelerate
Channel: Stone Barnard
Date: 2020-10-20

Create your own functions in excel to Count and Sum based on color cell background (Conditional formatting applied).

This is also a great how to tutorial regarding conditional formatting in excel.

Get the practice file and cheat-sheets by clicking on the following link:
https://drive.google.com/drive/folders/1dd1nYmXDysgwEWwnfryDtsGZ4olYzZ7x?usp=sharing
 
a MASSIVE thank you to all the subscribers...Nice!

Subscribe for more excel awesomeness by following the link:
https://www.youtube.com/channel/UC1up...

Please check out my previous episodes to gain some excel knowledge:

Episode 1   | User form in excel VBA   | https://youtu.be/F1fcGQJKASQ
Episode 2   | Picture lookup in excel    | https://youtu.be/eESammr1Gzk
Episode 3   | Log in function in excel   | https://youtu.be/X1aBnwpBQLw
Episode 4   | Waterfall chart in excel   | https://youtu.be/h44xyF2wnIE
Episode 5   | Combo Boxes in excel     | https://youtu.be/Ie5UU0IOgkw
Episode 6   | Vlookup Speed Run          | https://youtu.be/qj7yKalJCo4
Episode 7   | Index in VBA and excel    | https://youtu.be/YpmEWprV4z4
Episode 8   | Pivot table in excel VBA   | https://youtu.be/4CIRg8eU1wk
Episode 9   | Loan calculator in excel   | https://youtu.be/TjuuVkCMyr8
Episode 10 | 100 Subscriber episode   | https://youtu.be/izsvfZEYbV8
Episode 11 | Vlookup in excel & VBA   | https://youtu.be/6s1zxRS27K0
Episode 12 | Investment calculator      | https://youtu.be/-OFUankN9nk
Episode 13 | Pipe charts in excel          | https://youtu.be/NB5EGBr3GRA
Episode 14 | Auto Candlestick graphs | https://youtu.be/5s0BR55oYAk
Episode 15 | Bullet charts in excel        | https://youtu.be/d09aeUbi7mA
Episode 16 | Record Macro in Excel     | https://youtu.be/5uiYOhc4GO8
Episode 17 | Pop-up Calendar in Excel | https://youtu.be/jC_WkOY32eY
Episode 18 | 5 Top Table Tips in Excel | https://youtu.be/2NMWfjgVgoc
Episode 19 | Excel game for free           | https://youtu.be/BOnFXYNhrtY

Check out my Facebook page and share my content by following the link: https://www.facebook.com/stone.barnard

Please comment below if you have an idea for a tutorial or would like to reach out!

Buckle-up and let's Excelerate!