+ Reply to Thread
Results 1 to 2 of 2

conditional formating - change cell color based on the date in another cell

  1. #1
    Registered User
    Join Date
    10-03-2013
    Location
    San Jose
    MS-Off Ver
    Excel 2010
    Posts
    1

    conditional formating - change cell color based on the date in another cell

    Hi,
    before I post the problem that I am facing with I would like to say that I have read most of the threads posted on this and other excel related forums. I was looking for the solutinion of my problem but at the end it looks like I am not good enough to solve this problem on my own.
    And the problem is (as attached):
    I have two columns. In column B is the date of "last check". I column A is the date of "next check". I would like to have cell A2 in yellow color 334 days after the date entered in cell A3 and than in red color 365 days after the date entered in cell A3. Same thing for cell B2 related to date entered in cell B3. Yellow color in cells announces that check will expire within 30 days and red color that check has been expired.

    I hope that I have described it well and would like to thank anyone who can help
    Attached Files Attached Files

  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
    53,044

    Re: conditional formating - change cell color based on the date in another cell

    Hi and welcome to the forum

    Hopefully, I have this the right way round (if not, swap the references around)...

    1. highlight the range you want to apply the conditional formatting to
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =A2-A3>334
    repeat 3&4 for the 2nd rule
    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

+ 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 formating Combo Box with Color based on another cell
    By scange in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2013, 11:39 AM
  2. Replies: 5
    Last Post: 05-10-2012, 10:49 PM
  3. Conditional Formating based on the fill color of a cell
    By mfrymyer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2010, 02:16 PM
  4. conditional formating based on change in same cell
    By chesterfield in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2008, 08:44 AM
  5. [SOLVED] Conditional formating-cell change color
    By scott45 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-04-2005, 12:05 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