#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
From an XL sheet ,how to keep the group of columns which match with other XL sheet | Zubairkhan | Excel | 2 | 03-04-2014 10:57 PM |
How to set a hyperlink from a pp presentation into a CELL from an excel sheet | Sabi | PowerPoint | 1 | 04-30-2013 06:36 AM |
sheet 2 data highlight in sheet 1 | gsrikanth | Excel | 1 | 04-21-2012 06:25 PM |
Construct a summary sheet by summing up from one or more than one sheet. | PRADEEPB270 | Excel | 1 | 11-04-2011 03:46 AM |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |