+ Reply to Thread
Results 1 to 3 of 3

Need a 'conditional formatting' formula to highlight cells between dates/text

  1. #1
    Registered User
    Join Date
    12-29-2014
    Location
    georgia
    MS-Off Ver
    2007
    Posts
    2

    Need a 'conditional formatting' formula to highlight cells between dates/text

    Hello Excel Help Forum!

    I'm sure there is a simple explanation for this but I'm having trouble coming up with it. In the attached excel you'll see on the LRC tab a series of dates that are highlighted. The start and end of the project is 10 -15 jan and I'd like that entire area to be highlighted in red not just the start and end dates. And not just that particular one but any of them in the future that have "start" and "end" on them.

    sean175Tracker_Clean-2.xlsx

    Any suggestions?

    Thanks!

  2. #2
    Registered User
    Join Date
    09-07-2013
    Location
    Brussels
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Need a 'conditional formatting' formula to highlight cells between dates/text

    Select your range
    Click "conditional formatting" in the menu
    Select "new rule"
    Select "use a formula ...."
    Enter this formula for instance: =NOT(ISBLANK(B1)) where B1 is supposed to have "Start" as value
    Define the format you need and OK

  3. #3
    Registered User
    Join Date
    12-29-2014
    Location
    georgia
    MS-Off Ver
    2007
    Posts
    2

    Re: Need a 'conditional formatting' formula to highlight cells between dates/text

    Thanks but that highlights all blank cells, which most of them are. Or, if I select and apply that particular conditional formatting to a set of cells I might as well just highlight them manually.

+ 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. [SOLVED] Can Conditional Formatting highlight cells containing any formula?
    By tuph in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-23-2014, 11:27 PM
  2. Replies: 0
    Last Post: 08-12-2013, 03:06 PM
  3. Using Conditional Formatting to highlight cells based on approaching dates
    By BrutalExcel in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 06-12-2013, 11:56 AM
  4. [SOLVED] Excel 2010 Conditional Formatting to Highlight input cells based on Dates
    By chrisb84 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-20-2013, 09:39 AM
  5. Replies: 5
    Last Post: 09-24-2012, 05:14 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