1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel/Highlight Row Based on Date

Discussion in 'Business Applications' started by computerman29642, Aug 7, 2013.

Thread Status:
Not open for further replies.
  1. computerman29642

    computerman29642 Thread Starter

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    I am trying to create a code that will highlight an entire row the day before the date entered into a cell on that row.
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,910
    First Name:
    Wayne
    use conditional format
    add a formula

    =cell with the date = today()+1
    that will be true if the date

    just to make sure we understand

    today() is 7th August
    the date in the cell is 8th august
    so you want it highlighted

    so cell = 8th
    today + 1 = 8th
    it highlights

    now to highlight the row
    use a $ on the cell that has the date and apply to the whole row

    so if the date is in column C and say row 5

    then
    $C5 = today()+1

    in the conditional format formula and apply to
    $A$5:$Z$5
    or whatever column you need

    a sample spreadsheet would be useful , you can attach here
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1105509

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice