+ Reply to Thread
Results 1 to 5 of 5

Conditional Format to highlight cell based on corresponding date..

  1. #1
    Registered User
    Join Date
    06-27-2013
    Location
    Sainte Genevieve, MO
    MS-Off Ver
    Excel 2003
    Posts
    21

    Conditional Format to highlight cell based on corresponding date..

    Not very good at this but I have the basic sheet attached. All I want is a way to highlight the first cell when the date is within 30 days of the "Due date".

    Simple calibration sheet to let us know when gages are due for calibration. Calibration Record-example.xls

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Conditional Format to highlight cell based on corresponding date..

    I think that this does what you want.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    06-27-2013
    Location
    Sainte Genevieve, MO
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Conditional Format to highlight cell based on corresponding date..

    That's pretty much what I am looking for.
    What does the -$K1 represent? I am going to try and apply this in other areas as well.

    I appreciate the help!

  4. #4
    Registered User
    Join Date
    06-27-2013
    Location
    Sainte Genevieve, MO
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Conditional Format to highlight cell based on corresponding date..

    Nevermind got it!

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Conditional Format to highlight cell based on corresponding date..

    Thank you for the feedback.

+ 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. Conditional format a cell based on a due date
    By Taiter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-15-2013, 11:50 PM
  2. Using a macro to create a conditional format based on a date in a cell
    By srsev in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2012, 04:39 PM
  3. Replies: 5
    Last Post: 04-22-2011, 02:50 PM
  4. Conditional Format - Highlight based on the bottom row
    By MadCrammer in forum Excel General
    Replies: 2
    Last Post: 08-24-2010, 12:52 PM
  5. Conditional Format based on date of another cell
    By marjo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2008, 02:41 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