software

I read previous posts about not being able to trigger a macro through a
function. So my question is: Is there any way to have the macro see
that the IF function is at quot;truequot;, or falsequot;?

What i am doing is i have an nested if function that says wheather a
person's rent is due today, due soon, is late, or is good. My macro
changes the sheet tab color to red. Now what i need is for the sheet
tab color to be red if the rent is due.

What would be ideal is if it was orange if its due within 30 days and
then bright red if its due or late and white if it is good.

Anyone have any ideas or tips on how i can accomplish this goal?

This is my nested IF function:

quot;=IF($I$24=TODAY(),quot;Duequot;,IF($I$24lt;TODAY(),quot;Overdue quot;,IF($I$24lt;NOW() 30,quot;Lease
is endingquot;,quot;OKquot;)))quot;

And my macro right now i just recorded to change the sheet tab to red.

Any tips will be extremely appreciated. Thank you for your time and
help.

Sincerely,
LeonHi Leon,

See response to your post in Programming.---
Regards,
Norman
quot;Leonquot; gt; wrote in message ups.com...
gt;I read previous posts about not being able to trigger a macro through a
gt; function. So my question is: Is there any way to have the macro see
gt; that the IF function is at quot;truequot;, or falsequot;?
gt;
gt; What i am doing is i have an nested if function that says wheather a
gt; person's rent is due today, due soon, is late, or is good. My macro
gt; changes the sheet tab color to red. Now what i need is for the sheet
gt; tab color to be red if the rent is due.
gt;
gt; What would be ideal is if it was orange if its due within 30 days and
gt; then bright red if its due or late and white if it is good.
gt;
gt; Anyone have any ideas or tips on how i can accomplish this goal?
gt;
gt; This is my nested IF function:
gt;
gt; quot;=IF($I$24=TODAY(),quot;Duequot;,IF($I$24lt;TODAY(),quot;Overdue quot;,IF($I$24lt;NOW() 30,quot;Lease
gt; is endingquot;,quot;OKquot;)))quot;
gt;
gt; And my macro right now i just recorded to change the sheet tab to red.
gt;
gt; Any tips will be extremely appreciated. Thank you for your time and
gt; help.
gt;
gt; Sincerely,
gt; Leon
gt;