Function triggering a macro
 

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 "true", or false"?

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:

"=IF($I$24=TODAY(),"Due",IF($I$24<TODAY(),"Overdue ",IF($I$24<NOW()+30,"Lease
is ending","OK")))"

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,
Leon

Function triggering a macro
 

Hi Leon,

See response to your post in Programming.


---
Regards,
Norman



"Leon" wrote in message
ups.com...
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 "true", or false"?

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:

"=IF($I$24=TODAY(),"Due",IF($I$24<TODAY(),"Overdue ",IF($I$24<NOW()+30,"Lease
is ending","OK")))"

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,
Leon