Hello everyone,
May I ask is excel able to perform any action (mathematics, for example) by identifying the cells or the text colour?
For example, I put a random number between 0 to 100 at cells A1 to A50. After that I format some of the text so the text appears red colour.
Hence, can I ask excel to sum up all the values with black coloured text and minus all the values that appears red in colour?
Bookmarks