Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-27-2017, 08:59 AM
solberg2004 solberg2004 is offline Conditional Formatting Windows 7 64bit Conditional Formatting Office 2007
Novice
Conditional Formatting
 
Join Date: Jan 2017
Posts: 2
solberg2004 is on a distinguished road
Default Conditional Formatting

Hi all



I am having trouble trying to set up conditional formatting on a spreadsheet.

A description of the layout is as follows:

Cell A1: Date invoice issued for Approval
Cell B1: Approved Invoice Return Due Date
Cell C1: Approved Invoice Actual Return Date

Cell A2: 09/01/2017
Cell B2: 16/01/2017
Cell C2: Blank


When an invoice goes for approval it must be approved within 7 days.

Point 1: I want to set up a formula that when the invoice date for approval is entered (Cell A2) the return due date automatically comes up (Cell B2).

Point 2: If an invoice is not returned by the due date I want excel to automatically flag this cell a RED colour after the 7 days has elasped.

Point 3: If the approved invoice comes back after the 7 days, the cell has already flagged up red, but when the actual return date is manually entered I want Cell B2 to go ORANGE.

Point 4:If the approved invoice comes back before the 7 days Cell B2 shall remain GREEN as it is within the 7 day timeframe.

Any help in inputting these conditional formats and formulas would be greatly appreciated.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Conditional formatting otuatail Excel 11 07-11-2016 11:30 PM
Conditional Formatting grexcelman Excel 8 01-12-2015 10:27 AM
Conditional Formatting Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Conditional Formatting teza2k06 Excel 3 01-19-2014 02:34 AM
conditional formatting otuatail Excel 1 06-06-2012 05:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:29 PM.


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