View Single Post
Old 06-20-2014, 01:11 PM
Aeducan Aeducan is offline Windows 7 64bit Office 2013
Join Date: Jun 2014
Posts: 1
Aeducan is on a distinguished road
Default 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.
Reply With Quote