Forum Discussion
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 ...
The most a function can do at present to detect color is very limited.
If the cell contains a negative value that is custom cell formatted to appear in red, for example, you may use CELL to determine if it contains color:
E1 is custom cell formatted with: [Red][<0]0;[>0]0
Thank you
