Excel: How to get Text Font color as a number to use it for sum and count functions

An easy way, without writing code, with an example for summing and counting cell values based on text color, also using Advanced Filter to remove duplicate values and a quick command to copy a formula without changing cell references. Copy & Paste all formulas from: 1st part: https://www.showtechies.com/excel-com... 2nd part: https://www.showtechies.com/excel-com...