How to make -number out as words

[msacswt]

Have a logic as follow:




If satisfying condition A, use calculation x-y, If x-y>0 take the result, if x-y<0, show "Red", If satisfying condition B, use x-z, if x-z>0 take the result, if x-z<0, show "Red".

x, y and Z are all date. X is today.

How to put function in a form field?

Thank you very much !

[ranman256]

use CONDITIONAL FORMATTING

[msacswt]

Would you please give more detailed procedure?

Red highlighted is <Required>, Green is conditions.

Days Late	Due Date	Extension Date	Closed Date
[Closed date]-[Extension]	X	X	X
[Closed Date]-[Due Date]	X		X
Today-[Extension Date]	X	X
Today- [Due Date]	X

Currently we do not need output as words, but need the requirement as above.

In other words, 3 dates (Due date], [Extension Date] and [Closed Date], and 4 calculations.

We tried different ways to use IIf function and finally solved it.


Thank you very much!