excel developer codes

Occasional Contributor

Hi, i have recently learnt how to enter a code in to the developer to enable the auto sum of cells with the same background colour. i was wondering if there is a code out there like this that will allow me to auto sum the cells with the same border colour. if so can you tell me the code or how to do it thanks  i dont know much about the developer side of things i just copied what a youtube tutorial said. thanks kelly

1 Reply
Hi Kelly,

Using formatting of cells to do calculations isn't a very good solution. It requires VBA programming which is not very easy to maintain unless you know what you are doing. It is better (and more efficient) to base your calculations on the content of the cells so you can use built-in functions like SUMIF, SUMIFS and their look-a-likes.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies