Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2014, 01:11 PM
Aeducan Aeducan is offline Help Coloring a cell in Sheet one if data is missing from another sheet Windows 7 64bit Help Coloring a cell in Sheet one if data is missing from another sheet Office 2013
Novice
Help Coloring a cell in Sheet one if data is missing from another sheet
 
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
  #2  
Old 06-22-2014, 04:49 PM
ImAhNoBoDy ImAhNoBoDy is offline Help Coloring a cell in Sheet one if data is missing from another sheet Windows 7 64bit Help Coloring a cell in Sheet one if data is missing from another sheet Office 2007
Novice
 
Join Date: Jan 2012
Posts: 9
ImAhNoBoDy is on a distinguished road
Default

I think this video might help you out:

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Coloring a cell in Sheet one if data is missing from another sheet 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
Help Coloring a cell in Sheet one if data is missing from another sheet 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
Help Coloring a cell in Sheet one if data is missing from another sheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft