Closed Thread
Results 1 to 2 of 2

How do I conditionally format entire rows based on a cell conditionally formatted by date?

  1. #1
    Registered User
    Join Date
    01-04-2017
    Location
    Dublin
    MS-Off Ver
    2013
    Posts
    2

    How do I conditionally format entire rows based on a cell conditionally formatted by date?

    Hi All,

    The pic below is what I'm working with. I've created a calendar of cycling events occurring throughout the year. I want to highlight in RED what's finished, GREEN what's occurring this week and YELLOW what's happening next week. I've been able to conditionally format the cells with the date in them but how do I apply this to the entire row? Thanks in advance for your help.

    Shane

    Excel Query.JPG

  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: How do I conditionally format entire rows based on a cell conditionally formatted by d

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    http://www.excelforum.com/showthread.php?t=1168547
    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

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-04-2017, 06:00 PM
  2. Conditionally format entire row based on cell selection
    By Geogee in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-18-2015, 07:04 AM
  3. conditionally format entire row for dates 15 days past today's date?
    By chalter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2014, 11:46 AM
  4. Replies: 4
    Last Post: 07-04-2013, 11:28 AM
  5. Need a macro to delete row based on conditionally formatted cell
    By twinklestar922 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2013, 06:47 AM
  6. Clear contents based on colour of a conditionally formatted cell
    By mit400 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-24-2011, 10:14 AM
  7. VBA code to check format of conditionally formatted cell
    By macquarl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-19-2008, 11:52 AM

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