#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Hi and welcome
please post a sample sheet ( click Go Advanced -Manage attachments) containing some data, what you already tried, and what went wrong
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting | otuatail | Excel | 11 | 07-11-2016 11:30 PM |
Conditional Formatting | grexcelman | Excel | 8 | 01-12-2015 10:27 AM |
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 |