Microsoft Office Forums Conditional Formatting

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 01-27-2017, 09:37 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,383
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hi and welcome
please post a sample sheet ( click Go Advanced -Manage attachments) containing some data, what you already tried, and what went wrong
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 01-27-2017, 10:07 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

I have attached the excel spreadsheet and what i have been trying to achieve so far.
There is a formula and some conditional formats in aswell.

Cheers
Attached Files
File Type: xlsx Invoice Record Sample.xlsx (85.3 KB, 2 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 06:36 PM.


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