u/KeyCombination5969

I’d like to be able to create something where if I colour let’s say D5 in a colour, K5 is automatically made that same colour and all cells in the H column of that colour only are added to a total in ,for example, Q10.

Sorry if I haven’t given much of a description to what I would like to do im still quite new to excel, but any suggestions and advice would be really appreciated.

Edit: thank you for the quick responses! I’ll see what I can accomplish with conditional formatting as it’s completely new to me and hopefully I can come back with some good news!
Really appreciate the advice.