I am looking for a couple formulas, possibly VBA.
1. To count all cells in a column which has double underlined text.
2. To count all cells in a column which has text both in a certain color (purple 10498160) and bold. It cannot just find bold, it must be both bold and that color in the same text, because other words might be in bold in the same cell, but not purple.
Thank you for whatever help you can offer.