If and Color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark Cooney - 21 Nov 2007 10:29 GMT

Hello

=(IF(ISNUMBER(G3),G3,E3))

I am using the following very simple if statement. If "TRUE" i want the
reference from G3 to be
green and if false the reference E3 to be red.

Any ideas?

MC

Reply to this Message

Dave Peterson - 21 Nov 2007 13:34 GMT

You could use format|conditional formatting (xl2003 menu system)
and just compare the cell with the formula in it to G3 in the first rule.

And the cell with the formula in it to E3 in the second rule.

> Hello
>
[quoted text clipped - 7 lines]
>
> MC

Signature

Dave Peterson

Reply to this Message

MartinW - 21 Nov 2007 13:41 GMT

Hi Mark,

You can do that with conditional formatting

Say your formula is in H3

Select H3 and go to Format>Conditional Formatting
Choose cell value - is equal to - G3
Click Format button and select font color green
Click Add
Choose cell value - is equal to - E3
Click Format button and select font color red.
OK out

You may need to go back into Conditional Formatting
and remove the " " around the G3 and E3 references that Excel
has helpfully added for you.

HTH
Martin

> Hello
>
[quoted text clipped - 7 lines]
>
> MC

Reply to this Message

Rate this thread: