•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Changing/Automated icons when a checkmark box is ticked?
Our take
Transforming mundane checkboxes into engaging visuals can elevate your spreadsheet experience. Inspired by a GoogleSheetsPro template, you can create a dynamic system where icons, like flower pots, change as tasks are completed. This gamified approach not only makes tracking progress enjoyable but also enhances productivity. While the original design may be in Google Sheets, similar functionality can be achieved in Excel using conditional formatting and creative icon choices.
I saw a template made by GoogleSheetsPro on Etsy that had a couple of automated tables and charts, but what stood out for me most was the flower growth one. Every checkbox ticked on a to-do/task table had a flower pot icon change into making the flower slowly grow as more boxes were ticked.
How is this done? The charts and tables aren't of any
priority, I'm more interested in how they made it fun with
icons like a little game. I know it's Google Sheets, but I believe this might be possible with excel. I'd like to implement something similar to my personal sheets! Any help is appreciated.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#google sheets#Excel alternatives for data analysis#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#interactive charts#automated anomaly detection#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Google Sheets#automated icons#Excel#checkbox#flower growth#checkmark box#to-do table#task table#icon change#personal sheets