00:00I recently published a video on how you can sum numbers based on cell colors, but someone had inquired, how
00:06did I make this multiple colors on my cell?
00:09Well, this is how I do it. You're going to right click on the sheet name, select view code from
00:14the context menu.
00:15In here, you're going to paste this VBA subroutine. If you'd like the copy of this subroutine, please leave a
00:20request on the comment section and I'll send it to you.
00:22Once that's done, you're going to press Ctrl S. I'm going to move this VBA editor on the side here
00:27and select the area that I want to change the color on.
00:30Now go back to your VBA here, place your cursor on this subroutine and press F5.
00:36And you can see that the fill color changes every time you place your cursor on the subroutine and then
00:41press F5.
Comments