RE: Iff Statements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lisa - 13 Feb 2008 16:38 GMT

Does anyone know how to change the Font color using an IIf statement? I wan
Past Due to be in red.
=IIf([Text61]>0,"Past Due")

Signature

Lisa S.

Reply to this Message

Dale Fye - 13 Feb 2008 16:45 GMT

Select the text box, then on the main menu, select Format - Conditional
formatting.

Then select "Cell Value Is", "Greater than", and enter 0 in the last box.

Then click the "Format" button in the Conditional Formatting dialog and set
your foreground and background colors to whatever you want them to be, I
usually set the background to one of the shades of red and set the foreground
to Bold White.

HTH
Dale

Signature

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

> Does anyone know how to change the Font color using an IIf statement? I wan
> Past Due to be in red.
> =IIf([Text61]>0,"Past Due")

Reply to this Message

Glint - 14 Feb 2008 15:14 GMT

Hi,
I use this frequently, but I have also observed that sometimes, it fails,
and I cannot figure out the reason. What am I overlooking?

Signature

Glint

> Select the text box, then on the main menu, select Format - Conditional
> formatting.
[quoted text clipped - 12 lines]
> > Past Due to be in red.
> > =IIf([Text61]>0,"Past Due")

Reply to this Message