Tenants ledger report

[Pupabella]

Hi
I am working on a tenants worksheet with the following information
Apartment #, tenants name, lease term, collectible rent, security deposit
I want to add to this work sheet
One year renewal % increase
Two year renewal % increase
And get the result in dollar amount

Also if there is a way that this worksheet can highlight for me the tenants whose leases are about to expire in the next three or four months and need new lease renewals to be applied with the
One and two year increase as stated above.

I would appreciate some assistance
Thank you

[DGagnon]

you can do that with conditional formating, if you could supply a sample sheet and specific criteria im sure someone here can help you out.

[Pupabella]

Thank you for your reply
I will work on a sample report and put it here today

[Pupabella]

hi again, here is a sample ledger sheet, of what i am trying to do,

Book1.xls

thank you

[DGagnon]

you can use this formula to calculate the new rent:

F3
=E3*(1+$F$2)

G3
=E3*(1+$G$2)

and this for conditional formating:

=DATEVALUE(TRIM(RIGHT(SUBSTITUTE($C3,"-",REPT(" ",100)),100)))<=(TODAY()+120)


please see the attached as well.

[Pupabella]

"God" bless you, you have helped me a great deal, thank you very much