MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IF statement where font changes color


Posted by jani on April 17, 2001 6:46 AM

Would someone help me with this formula? I have been
trying to get an IF statement to work but have not
been successful.

If A1-B1 is equal to or less than C1, then show the
result in red font; if the result of A1-B1 is greater
than C1, then "CHECK".


Posted by Stephane Parent on April 17, 2001 7:42 AM

Hi jani,

Try this in the cell:
=if(a1-b1>c1,"CHECK",c1)

and try using conditionnal formatting from the format menu, setting "cell value is" "not equal to" type CHECK is the third box and finally choose red at the bottom.

There is probably ten other methods...

Stephane Parent

Posted by Aladin Akyurek on April 18, 2001 12:55 PM

=================

Stephane: Great suggestion that combination. While looking at it, I thought that 3rd arg of IF should perhaps read a1-b1.

Aladin

Posted by Stephane Parent on April 19, 2001 6:17 AM

Aladin is right

You're right, I misread the original request...

Stephane Parent