Hey all,

I am trying to create a spreadsheet for rentals. My plan is to have a specific sheet for each item and have sheet 1 be a quick overview of all of the other sheets. I would like for the item to become red on sheet 1 if I do not insert a payment by a certain day. I have some Excel knowledge but have never delved too deep into Conditional formatting or even cross sheet linking so any help would be greatly appreciated. On another note, is there a way to make late fees automatically add in if a payment is not made by a specific date so I have all pertinent information in just a glance instead of manually calculating that in? Thanks and sorry for the double question.

I think this video might help you out:

https://www.youtube.com/watch?v=clxQIu-_A6Y