Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Mar 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Formula (2003)

    I need some help, please
    I want to use a conditional format that will read a specified Status Column (G) and a date column (T) with a +7 days to bold Red a text column (E)..Example: Status Column G=Review, Date, column T date of March 15 then when +7 days occur, turn text column E bold red.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Formula (2003)

    Welcome to Woody's Lounge!

    Could you explain in more detail? I'm not sure whether you mean that column G will contain a status description (such as "Review") or that it will contain a date.
    It might also be helpful if you could attach a small sample workbook (the data may be fake).

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Formula (2003)

    The following assumes your Date field is in column F. It will return a True value - apply your conditional formatting - if cell G1 = "Review" and the date in T1 is more than 7 days greater than the date in F1.

    =AND(G1="Review",T1-F1>7)

  4. #4
    New Lounger
    Join Date
    Mar 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Formula (2003)

    Column E is a text name, Column G s a text reference step in a drop down, Column T is the date a item is received. I am trying to Bold Red alert. If Column T date field >7 days past the posted field and Column G = a specified condition then I want Column E to turn Bold Red.Example: If something is delivered March 10 (Column T) and Column G is specified that it is in review then I want Column E to turn Bold Red because is has pasted March 17 deadline to process. I am sorry but I cannot provide a copy of the spreadsheet.I hope this helps because I am lost.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Formula (2003)

    I'm still not sure I have understood your description correctly, but try this:

    - Select the cells in column E you want to apply conditional formatting to.
    - Note which cell is the active cell (its address is displayed in the box to the left of the formula bar). I'll assume it is C1, if it is in another row, adjust the formula below accordingly.
    - Select Format | Conditional Formatting...
    - Select Formula Is in the first dropdown.
    - Enter the following formula in the box next to it:
    <code>
    =AND($G1="Received",TODAY()>$T1+7)
    </code>
    - 1 is the row of the active cell, adjust as needed.
    - Click Format... and specify Bold and Red in the Font tab.
    - OK your way out.

  6. #6
    New Lounger
    Join Date
    Mar 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Formula (2003)

    Thank you Hans, the formula works perfect. I appreciate your help.
    writerman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •