I have a personal finance sheet that calculates a simple balance (in
Cell F1).

Next to the balance (in Cell G1) I have an IF function that inputs text
depending on the current balance. It is as follows:

=IF(F10,N9,N10)

(where N9 = BALANCE OK and N10 = WARNING OVERDRAFT ENTERED)

Is It possible to force excel to colour the cell depending upon the
message that is displayed.

i.e. if the balance is -100, then the message is WARNING OVERDRAFT
ENTERED - I would like this to be displayed in red or have the coloured
in red.

If it displays BALANCE OK, I would like the text to be Blue (or the
cell clour to be Blue).

Can this be done?

go to Format, Conditional Formatting, and define your criteria much the
same as your if statement.

something like, Cell value, is equal to, ="WARNING OVERDRAFT" and then
apply red colouring, and add another conditional for the balance ok
with a blue fill

Duncan




wrote:

I have a personal finance sheet that calculates a simple balance (in
Cell F1).

Next to the balance (in Cell G1) I have an IF function that inputs text
depending on the current balance. It is as follows:

=IF(F10,N9,N10)

(where N9 = BALANCE OK and N10 = WARNING OVERDRAFT ENTERED)

Is It possible to force excel to colour the cell depending upon the
message that is displayed.

i.e. if the balance is -100, then the message is WARNING OVERDRAFT
ENTERED - I would like this to be displayed in red or have the coloured
in red.

If it displays BALANCE OK, I would like the text to be Blue (or the
cell clour to be Blue).

Can this be done?

sure, use Format=conditional formatting.

If you are not familiar with it, see Debra Dalgleish's site
http://www.contextures.com/tiptech.html

look at conditional formatting in the index.

--
Regards,
Tom Ogilvy


" wrote:

I have a personal finance sheet that calculates a simple balance (in
Cell F1).

Next to the balance (in Cell G1) I have an IF function that inputs text
depending on the current balance. It is as follows:

=IF(F10,N9,N10)

(where N9 = BALANCE OK and N10 = WARNING OVERDRAFT ENTERED)

Is It possible to force excel to colour the cell depending upon the
message that is displayed.

i.e. if the balance is -100, then the message is WARNING OVERDRAFT
ENTERED - I would like this to be displayed in red or have the coloured
in red.

If it displays BALANCE OK, I would like the text to be Blue (or the
cell clour to be Blue).

Can this be done?

You can just use conditional formatting. Format - Conditional Formating -
Formula Is =$N$9 ... then set your formating

--
HTH...

Jim Thomlinson


" wrote:

I have a personal finance sheet that calculates a simple balance (in
Cell F1).

Next to the balance (in Cell G1) I have an IF function that inputs text
depending on the current balance. It is as follows:

=IF(F10,N9,N10)

(where N9 = BALANCE OK and N10 = WARNING OVERDRAFT ENTERED)

Is It possible to force excel to colour the cell depending upon the
message that is displayed.

i.e. if the balance is -100, then the message is WARNING OVERDRAFT
ENTERED - I would like this to be displayed in red or have the coloured
in red.

If it displays BALANCE OK, I would like the text to be Blue (or the
cell clour to be Blue).

Can this be done?

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
I have a personal finance sheet that calculates a simple balance (in
Cell F1).

Next to the balance (in Cell G1) I have an IF function that inputs text
depending on the current balance. It is as follows:

=IF(F10,N9,N10)

(where N9 = BALANCE OK and N10 = WARNING OVERDRAFT ENTERED)

Is It possible to force excel to colour the cell depending upon the
message that is displayed.

i.e. if the balance is -100, then the message is WARNING OVERDRAFT
ENTERED - I would like this to be displayed in red or have the coloured
in red.

If it displays BALANCE OK, I would like the text to be Blue (or the
cell clour to be Blue).

Can this be done?