+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting or Functions

  1. 06-24-2014, 12:09 AM #1
    Shabir
    Shabir is offline
    Registered User
    Join Date
    06-23-2014
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    2

    Cool Conditional Formatting or Functions

    Hi Everyone,

    I am using the 2013 version of Excel and have some minor work to do and i am done with my project work.

    I have a list of future dates in one entire column (F1). I need to format the cells to automatically highlight dates when there is 6 months to the date. Eg Column F1 reflects 01 January 2015 and i need it to highlighted once i reach 01 July 2014. This formula needs to be applied to the whole column with the future dates.

    I am an absolute noob in formulas, functions and conditional formatting. Someone please help me out.

    Thanks so much.
    Reply With QuoteRegister To Reply
  2. 06-24-2014, 12:51 AM #2
    FDibbins
    FDibbins is offline
    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
    52,936

    Re: Conditional Formatting or Functions

    Hi and welcome to the forum

    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 =F1<=EDATE(TODAY(),6) format fill as needed

    If you have a lot of these to do, it will be better if you put =TODAY() in its own cell (say A1) and then reference it...
    =A1<=EDATE($A$1,6)
    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 With QuoteRegister To Reply
  3. 06-24-2014, 02:14 AM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Conditional Formatting or Functions

    Quote Originally Posted by FDibbins View Post
    If you have a lot of these to do, it will be better if you put =TODAY() in its own cell (say A1) and then reference it...
    =A1<=EDATE($A$1,6)
    I think there is a typo. Shouldn't it be (If I am not wrong)
    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  4. 06-24-2014, 03:04 AM #4
    Shabir
    Shabir is offline
    Registered User
    Join Date
    06-23-2014
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    2

    Re: Conditional Formatting or Functions

    THANKS SO SO MUCH GUYS. Really appreciate your help.
    Reply With QuoteRegister To Reply
  5. 06-24-2014, 01:13 PM #5
    FDibbins
    FDibbins is offline
    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
    52,936

    Re: Conditional Formatting or Functions

    Thanks for the catch sktneer, you are correct
    Reply With QuoteRegister To Reply
  6. 06-24-2014, 01:33 PM #6
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Conditional Formatting or Functions

    @Ford
    Thanks. I learn a lot from you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If functions and Conditional formatting
    By stpeter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2013, 11:03 AM
  2. IF Functions, Conditional Formatting
    By argegg26 in forum Excel General
    Replies: 3
    Last Post: 03-30-2010, 09:17 AM
  3. conditional formatting using IF with MID functions
    By jdubwelch in forum Excel General
    Replies: 6
    Last Post: 11-20-2007, 12:07 PM
  4. conditional formatting using IF with MID functions
    By jdubwelch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2007, 01:46 AM
  5. Conditional Formatting- Functions
    By jbroad in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-17-2007, 09:24 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1