Results 1 to 8 of 8

Thread: Conditional Formatting on past dates
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2010
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional Formatting on past dates

    I would like to use conditional formatting so that if the dates in column c are older than today(current date), I would like them to turn red so that I can track past due accounts.
    Thank you very much.

  2. #2
    Board Regular NBVC's Avatar
    Join Date
    Aug 2005
    Location
    Ontario
    Posts
    5,828
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting on past dates

    Select column C, go to Home|conditional formatting, New Rule

    Select to "use a formula to determine which cells to format"

    Enter formula:

    =AND(C1<>"",C1
    Clcik Format and choose from Font or Fill tab.
    Where there is a will there are many ways. Finding one that works for you is the challenge!

    Microsoft MVP - Excel (2010-2016)



  3. #3
    Board Regular
    Join Date
    Dec 2010
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting on past dates

    Thank you so very much. Can I copy conditional formatting to the rest of the cells in the same column?

  4. #4
    Board Regular NBVC's Avatar
    Join Date
    Aug 2005
    Location
    Ontario
    Posts
    5,828
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting on past dates

    Yes, or you can simply change the Applies to range to the range you want to apply it to.
    Where there is a will there are many ways. Finding one that works for you is the challenge!

    Microsoft MVP - Excel (2010-2016)



  5. #5
    Board Regular
    Join Date
    Dec 2010
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting on past dates

    Thank you very much, it worked perfectly! I appreciate quick responses.

  6. #6
    Board Regular kevatarvind's Avatar
    Join Date
    Mar 2013
    Location
    India
    Posts
    1,039
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting on past dates

    Hello NBVC can you pls help me in below metter


    Hi

    I have to do daily no's of vlookup and its taking lots of time now i got one code is below but its only doing one vlookup at one time and every time i have to change the range as per requirements so any body have any idea how can i do multiple vlookup in one time and fast way

    Sub Macro5()
    Range("K1").Select
    ActiveCell.FormulaR1C1 = "=VLOOKUP(RC10,Armine!C1:C3,2,0)"
    Range("J1").Select
    Selection.End(xlDown).Select
    Range("K25365").Select
    Range(Selection, Selection.End(xlUp)).Select
    Selection.FillDown
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    Application.CutCopyMode = False
    Selection.End(xlUp).Select
    End Sub



    thanks in Advance
    Arvind

  7. #7
    Board Regular NBVC's Avatar
    Join Date
    Aug 2005
    Location
    Ontario
    Posts
    5,828
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting on past dates

    Arvind,

    Please start a new thread with your topic. Please don't hijack other threads.
    Where there is a will there are many ways. Finding one that works for you is the challenge!

    Microsoft MVP - Excel (2010-2016)



  8. #8
    Board Regular kevatarvind's Avatar
    Join Date
    Mar 2013
    Location
    India
    Posts
    1,039
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting on past dates

    Quote Originally Posted by NBVC View Post
    Arvind,

    Please start a new thread with your topic. Please don't hijack other threads.
    Hi NBVC Sorry for that

    but i have posted this thread yesterday but no reply received from any one so thats why i tried here

    can you pls help on this

    yesterday thread link is below

    http://www.mrexcel.com/forum/excel-q...est-speed.html

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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