Change display color based on result

[Baylah]

Hi,

This has probably been asked, but I searched and can not fin an answer, so please forgive if it has been.

Is there a way that I can display the result of a calculation field in either RED or GREEN based on the result being positive or negative?

IF the result is a negative number I would like it to be red, and if positive GREEN. This is one of the first things I have ever found that is actually easier to do in Excel then it is in FileMaker. (at least of course unless I am missing something totally basic.

Thanks,

Steve

[Lee Smith]

You mean besides the colors availabe in layout mode, format, number?

[Baylah]

Geesh........................

I knew this had to be something simple!

How embaressing!

Oh my, thank you.

Steve

[Lee Smith]

LOL

I speak from personal experience.

Lee