Create a Sum Formula Based on Colored Cells in a Column

[snork79]

Hi! I'm a complete newb when it comes to macros and VBA. Have no idea what I am doing. I've tried watching some videos and looking at other resources/answers here and other places, but I'm a dunce I guess. I want to track my hours worked and I want to color a cell where I take vacation (PTO), then at the bottom I want to have a formula that will add just the colored cells. I don't think I can do it with conditional formatting, or I haven't found out a way to do it, where it doesn't include other "8" hour days. Help a girl out, please.

 

[dreid1011]

Welcome to the forum. Are you coloring the cells manually or with Conditional Formatting? If you are coloring them manually, then you would need to use VBA or define the conditions for coloring the cells and maybe a formula could be worked up for you. If you are using Conditional Formatting, then you can use the same formula conditions that determine which cells to color to get the sum.

 

[snork79]

Welcome to the forum. Are you coloring the cells manually or with Conditional Formatting? If you are coloring them manually, then you would need to use VBA or define the conditions for coloring the cells and maybe a formula could be worked up for you. If you are using Conditional Formatting, then you can use the same formula conditions that determine which cells to color to get the sum.

Manually. I know I need to use VBA, but I'm not sure what code to write. I've been looking at videos and other tutorials, but I'm a little clueless.

 

[dreid1011]

Is there a method to determining which cells you highlight?