If and Color

  • Thread starter Thread starter Mark Cooney
  • Start date Start date
M

Mark Cooney

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
 
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.
 
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
 
Back
Top