Help Coloring a cell in Sheet one if data is missing from another sheet
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.
|