TL;DR Key Takeaways : Conditional formatting in Excel 365 uses tools like data bars, color scales, and icon sets to visualize data trends, making analysis more intuitive and actionable.

Go to Data on the Ribbon, and in the Data Tools group, choose Data Validation. The Data Validation window that pops up allows you to set your criteria in many ways. For our example, choose Whole ...