Macro for sum and conditional formatting highlight

I would just like to say my boss and I appreciate the forum's answers to our queries. Truly.

Forum Sample.xlsxI have attached the spreadsheet in question, and I am very new to macros. I have a command button question. I would like to create two command buttons at the top of the sheet

1) One command button to sum up hours based on identical/different name and date combo. Column D uses the formula =IF(COUNTIFS($A$5:$A$12,A6,$B$5:$B$12,B6) = COUNTIFS($A$5:A6,A6,$B$5:B6,B6), SUMIFS($C$5:$C$12,$A$5:$A$12,A6,$B$5:$B$12,B6),""). Essentially would like the button to tally up hours in column D based on formula for future data that gets entered here.

2) A command button to highlight values based on hours (yellow 70-99, Red > 100).

Hopefully my question makes sense. Thanks in advance!

Try (One button)

Please Login or Register  to view this content.

Thanks a bunch. I will play around and ask if i have more questions