Conditional Formatting
Quality Analysis Report in Power BI
In this tutorial we are going to create a dynamic dashboard that analyses a production business where we have our data scattered in multiple files. With many products, employees and locations, the aud...
Do Magic with Excel Drop Lists …Dynamic Dependent Diminishing
In this project I show you how wow your boss, colleagues and clients by creating Dynamic Dependent Diminishing drop lists. At the Basic Level, using drop lists in your worksheet makes entering data an...
Change cell color based on value in Excel
Conditional Formatting is widely used in Excel and it enables us to change Font characteristics and change cell color based on value when the desired conditions are met In this tutorial I show you how...
