Soldato
- Joined
- 10 Sep 2008
- Posts
- 11,973
- Location
- Bangor, Northern Ireland
Hey guys,
Im wondering if it is possible to create an "IF" statement in Excel which relates to the colour of the text used?
Image for reference
Basically what I am hoping to achieve is when a payment goes out, I change the text colour to green and then magic happens where it adds the amount to the "Total Fixed Outgoings" cell. For example the total fixed outgoings for May should currently be £615.24, not £1733.43 as not everything has come out of the account yet, only the green totals.
Is this possible? If so could you explain how in extra special "talking to a moron" terms, as im pretty terrible with Excel...
Alternatively if there are any easier or better options which achieve the same result, feel free to enlighten me.
Many thanks
Im wondering if it is possible to create an "IF" statement in Excel which relates to the colour of the text used?
Image for reference
Basically what I am hoping to achieve is when a payment goes out, I change the text colour to green and then magic happens where it adds the amount to the "Total Fixed Outgoings" cell. For example the total fixed outgoings for May should currently be £615.24, not £1733.43 as not everything has come out of the account yet, only the green totals.
Is this possible? If so could you explain how in extra special "talking to a moron" terms, as im pretty terrible with Excel...
Alternatively if there are any easier or better options which achieve the same result, feel free to enlighten me.
Many thanks
