search for all record on excel that is in octorbor 2012

Posted on 2012-08-29
Last Modified: 2012-09-05
colume a is for mate datetime on excel how can i find where date time is on octorber 2012
Question by:teera
    LVL 22

    Expert Comment

    Try this:


    LVL 7

    Assisted Solution

    use conditional formatting.  
    Select the range
    select conditional formatting
    Select Use a formular to determine which cells to format
    In the formula us:

    Pick a fill colour
    Click OK
    Make sure the "applies to" is okay and click Apply
    LVL 43

    Accepted Solution

    Another way is to use data filter.

    If you have 2007 or later then you can simply select the desired month from the filters.
    In earlier versions you will have to give a < and > criteria.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now