Results 1 to 4 of 4

Thread: Conditional Formatting in Excel 2008 problem

  1. #1
    Neophyte SandyJohnakin's Avatar
    Join Date
    Mar 2015
    Location
    Saint Petersburg, FL
    Posts
    2
    Articles
    0
    Excel Version
    12.3.6

    Conditional Formatting in Excel 2008 problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have an excel spreadsheet with dates that I need to color based only on the year. It's very large and has been copied and recopied. I tried to put all the data into a new sheet with no formatting except to make number a date. I found a formula in searching online - =ISNUMBER(SEARCH("2015",D2)) - and it worked once. I inadvertently closed the sheet and now can't make the formula work again. Can anyone help?
    2/26/14 3/14/14 2/7/14 7/19/13 7/1/13
    3/7/14 10/9/15 7/10/13 8/12/13 3/25/15
    7/16/14 8/25/14 9/26/13 12/24/15 9/4/14

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =YEAR(D2)=2015


  3. #3
    Neophyte SandyJohnakin's Avatar
    Join Date
    Mar 2015
    Location
    Saint Petersburg, FL
    Posts
    2
    Articles
    0
    Excel Version
    12.3.6
    I just tried doing that but nothing happened. Maybe I'm putting the wrong cell reference in - should I be selecting the entire range of dates?

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Yes. Where D2 is top left most cell in the selected range.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •