+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting for TODAY

  1. #1
    Forum Contributor
    Join Date
    11-13-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    464

    Conditional Formatting for TODAY

    Hi,
    I am using Conditional Formatting and want to know what formula I would use if I wanted a value that is =to the current month. I'm using a drop down list that contains only the names of each month. The result of the drop down selection is appearing in a column that I want to format. So, G1=JANUARY. Since JANUARY is not the current month, I will be applying the format to alert the user that something is overdue.

    I cannot attach a workbook unfortunately.

    Thank you!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,739

    Re: Conditional Formatting for TODAY

    Which column contains your dates, and do you have a header row so the data starts from row 2?

    Pete

  3. #3
    Forum Contributor
    Join Date
    11-13-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    464

    Re: Conditional Formatting for TODAY

    They would start at J5:J26. The header is at J4

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,739

    Re: Conditional Formatting for TODAY

    Highlight those cells J5:J26 starting with J5, then click on Conditional Formatting | New Rule | Use a formula... , then enter this formula in the dialogue box:

    =AND(J5<>"",TEXT(J5,"mmmm")<>$G$1)

    Then click the Format button, choose the Fill tab and select your colour. Then OK your way out and Excel will automatically adjust the cell references to suit the highlighted cells.

    Hope this helps.

    Pete

  5. #5
    Forum Contributor
    Join Date
    11-13-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    464

    Re: Conditional Formatting for TODAY

    Thank you very much. It worked perfectly. You are awesome, sir!

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,739

    Re: Conditional Formatting for TODAY

    Glad to hear it - thanks for the kind words.

    Pete

+ 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. Conditional Formatting help with =Today()
    By Prosatinos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2013, 06:56 AM
  2. Replies: 6
    Last Post: 04-23-2012, 11:11 AM
  3. Conditional Formatting Today and Older
    By ConsbruckR in forum Excel General
    Replies: 7
    Last Post: 03-18-2009, 04:31 PM
  4. Conditional Formatting Cell < Today()
    By sagan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-21-2005, 11:05 AM
  5. Conditional Formatting ... Today() & More
    By Ken in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2005, 11:06 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