Learn tricks to format your reports in excel. By the end of this tutorial, you'll be able to identify the areas where you can use conditional formatting and where it doesn't help much.
We handle such situations with vba and format our report. The vba code has an advantage that once the logic is built, we can reuse it over and again for all similar type of reports.
Share this video with your peers and help them understand these basic problem statements in excel.