+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting

  1. #1
    Registered User
    Join Date
    09-17-2014
    Location
    Chicago
    MS-Off Ver
    2010
    Posts
    5

    Conditional Formatting

    Hi,

    Is it possible to use conditional formatting to color a row based on the value outside of the row?

    I have a large table with different deliveries and their information. I want to color an entire row yellow if it's been delivered within the past 3 days and red if it was delivered more than 2 weeks ago. I have set up a formula using the TODAY function that gives the number of days since delivery.

    From what I saw within creating a new rule in Conditional Formatting, I couldn't find anything that didn't apply solely directly the cell with the days since delivery.

    Thanks!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Conditional Formatting

    Hi, welcome to the forum

    Take a look at New Rule/Use Formula this is where you can use formulas for CF
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Conditional Formatting

    Select say A1

    Conditional Formatting
    New Rule

    Use a formula to determine...

    Enter the formula as required

    format as required
    Use Format painter (paintbrush icon) to copy to other cells
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    09-17-2014
    Location
    Chicago
    MS-Off Ver
    2010
    Posts
    5

    Re: Conditional Formatting

    Hi, Thank you!

    I'm having trouble conceptualizing what formula would be appropriate. Would an =IF(TODAY()-delivery date row 2 cell>=21,color cells A1-O1 red, none) work?

    In bold is what I'm trying to do, and in italics is the delivery date cell I would use for the formula. How would I go about coloring the cells in this instance?

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Conditional Formatting

    1. highlight the cells you want to apply the CF to (all the cells, but not whole rows)
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =A1>=today()-21 format RED

    repeat 3 and 4 for the other rule =A1<TODAY()-3

    (or whatever your rules are)

  6. #6
    Registered User
    Join Date
    09-17-2014
    Location
    Chicago
    MS-Off Ver
    2010
    Posts
    5

    Re: Conditional Formatting

    Thank you! I'll give it a shot and let you know if I have any problems!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  2. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  3. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  4. Delete Conditional Formatting conditions but keep cell formatting - Excel 2010
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 08:28 PM
  5. Replies: 3
    Last Post: 05-15-2012, 04:13 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1