The hollowed-out icons remain at the full height, as they correspond with the 100% values in my data. The colored icons, on the other hand, grow and shrink with my variable data.

To do this, first, select the data, and press Ctrl+C to copy it. Next, head to the worksheet where you want to duplicate the ...

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.