+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting Based on Today's Date

  1. #1
    Forum Contributor
    Join Date
    09-29-2011
    Location
    ɹǝpun uʍop
    MS-Off Ver
    2019
    Posts
    198

    Conditional Formatting Based on Today's Date

    Hi,

    I have a log that has several entries put in each day.

    I would like to have conditional formatting so that anything with today's date has the formatting (say, Bold type).

    Can someone please assist me? I just can't seem to make it work.

    Thanks as always, Paul.

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,859

    Re: Conditional Formatting Based on Today's Date

    Hi EdWoods,

    Yes it can be done can you post sample workbook here with expected result.

    Thanks
    Ankur

  3. #3
    Forum Contributor
    Join Date
    09-29-2011
    Location
    ɹǝpun uʍop
    MS-Off Ver
    2019
    Posts
    198

    Re: Conditional Formatting Based on Today's Date

    Hi,

    Please see attached.

    While today is 10/5/16 (in dd/mm/yyyy format), entire line to be bold.

    If I open up tomorrow (11/5/2016), it's no longer bold.

    Cheers.
    Attached Files Attached Files

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,859

    Re: Conditional Formatting Based on Today's Date

    Select the whole date and then press ALT->O->D, you will get a window naming conditional formating rule manager -> click on new rule you will get new formatting rule->select the last option called use as formula to determine which cells to format-> put =TODAY()=$A2 this formula into format values where this formula is true-> now click on format and format cells as you want then apply and then ok.

    Now the conditional formatting will work.

    Check the attached file.
    Attached Files Attached Files
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  5. #5
    Forum Contributor
    Join Date
    09-29-2011
    Location
    ɹǝpun uʍop
    MS-Off Ver
    2019
    Posts
    198

    Re: Conditional Formatting Based on Today's Date

    Ah, thanks. I was using NOW(), not TODAY()

    Cheers

  6. #6
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,859

    Re: Conditional Formatting Based on Today's Date

    Glad to help you and thanks for feedback and rep!!! :

+ 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. Replies: 13
    Last Post: 12-13-2015, 03:09 AM
  2. Conditional formatting with dates NOT based on today
    By bionerdette in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-13-2014, 07:13 PM
  3. Replies: 5
    Last Post: 04-07-2014, 06:02 AM
  4. [SOLVED] Conditional Formatting Based on TODAY() Function
    By rylock in forum Excel General
    Replies: 6
    Last Post: 11-22-2013, 07:25 PM
  5. Replies: 1
    Last Post: 09-30-2012, 03:01 PM
  6. Conditional Formatting Based on Today Function
    By Madball in forum Excel General
    Replies: 2
    Last Post: 01-18-2012, 10:37 AM
  7. Conditional formatting based on date - not today's!
    By HarveyDickinson in forum Excel General
    Replies: 1
    Last Post: 09-11-2009, 05:46 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