Help with excel formula relating to certain coloured text

I have a spreadsheet that I use for bills of how much and when they are due to be paid, I'm trying to find out if there is a formula that enables me to pick out a certain coloured text e.g. column A ...