Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Use IF statements to change text colour?

Hello, I have a budget document that I have made.

In the cell displaying the total income result after expenses, I want the cell to display the numeric text in GREEN if the number is 0 or above, or RED if the number is below zero/ "in the negatives".

I am guessing some kind of IF function would do the job, I just don't know how to make the IF function change the colour of the numeric text.

Let's say the cell containing the total was cell A10, the formula might be something like this…

=IF(A10>=0, "green", "red")

Of course, this formula would only display the word "green" or "red", instead of actually changing the colour of the number displayed…

Also, how do I use the IF statement in conjunction with the calculation needed to produce the total? Let's say that the cell A8 is the cell containing total income, cell A9 contains the total expenses, and cell A10 contains the result of income/expenses (A8-A9). How do I separate the if function from the subtraction formula used to produce the total? Will an ampersand do, like this?

A8-A9 & =IF(A10>=0, "green", "red")

Thanks for your time and effort!

Use IF statements to change text colour?

Hello, I have a budget document that I have made.

In the cell displaying the total income result after expenses, I want the cell to display the numeric text in GREEN if the number is 0 or above, or RED if the number is below zero/ "in the negatives".

I am guessing some kind of IF function would do the job, I just don't know how to make the IF function change the colour of the numeric text.

Let's say the cell containing the total was cell A10, the formula might be something like this…

=IF(A10>=0, "green", "red")

Of course, this formula would only display the word "green" or "red", instead of actually changing the colour of the number displayed…

Also, how do I use the IF statement in conjunction with the calculation needed to produce the total? Let's say that the cell A8 is the cell containing total income, cell A9 contains the total expenses, and cell A10 contains the result of income/expenses income-expenses (A8-A9). How do I separate the if function from the subtraction formula used to produce the total? Will an ampersand do, like this?

A8-A9 & =IF(A10>=0, "green", "red")

Thanks for your time and effort!

Use IF statements to change text colour?

Hello, I have a budget document that I have made.

In the cell displaying the total income result after expenses, I want the cell to display the numeric text in GREEN if the number is 0 or above, or RED if the number is below zero/ "in the negatives".

I am guessing some kind of IF function would do the job, I just don't know how to make the IF function change the colour of the numeric text.

Let's say the cell containing the total was cell A10, the formula might be something like this…

=IF(A10>=0, "green", "red")

Of course, this formula would only display the word "green" or "red", instead of actually changing the colour of the number displayed…

Also, how do I use the IF statement in conjunction with the calculation needed to produce the total? Let's say that cell A8 is the cell containing total income, cell A9 contains the total expenses, and cell A10 contains the result of income-expenses (A8-A9). How do I separate the if IF function needed to change the colour of the numeric text from the subtraction formula used to produce the total? Will an ampersand do, like this?

A8-A9 & =IF(A10>=0, "green", "red")

Thanks for your time and effort!

Use IF statements to change text colour?

Hello, I have a budget document that I have made.

In the cell displaying the total income result after expenses, I want the cell to display the numeric text in GREEN if the number is 0 or above, or RED if the number is below zero/ "in the negatives".

I am guessing some kind of IF function would do the job, I just don't know how to make the IF function change the colour of the numeric text.

Let's say the cell containing the total was cell A10, the formula might be something like this…

=IF(A10>=0, "green", "red")

Of course, this formula would only display the word "green" or "red", instead of actually changing the colour of the number displayed…

Also, how do I use the IF statement in conjunction with the calculation needed to produce the total? Let's say that cell A8 is the cell containing total income, cell A9 contains the total expenses, and cell A10 contains the result of income-expenses (A8-A9). How do I separate the IF function needed to change the colour of the numeric text from the subtraction formula used to produce the total? Will an ampersand do, like this?

A8-A9 & =IF(A10>=0, "green", "red")

Thanks for your time and effort!