Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 15

Thread: [Solved] If value is before today highlight line red

  1. #1
    Join Date
    3rd February 2004
    Location
    Sydney
    Posts
    51
    Hi, I want to be able to highlight the line red if the value in the G column is before today. I also want this to trigger an email to me to notify me.... does this make sense?....

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    23rd September 2003
    Location
    York
    Posts
    880
    Hi Syd,

    Try looking at Conditional Formatting in the Help system and playing around with that for your Highlighting problem.

    John

    ps: Excell is Event Driven. Thus an event must occur to trigger your email. What event would you like to link it to? This will give people a better stab at posting you a reply.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    3rd February 2004
    Location
    Sydney
    Posts
    51
    Originally posted by johnccc
    Hi Syd,

    Try looking at Conditional Formatting in the Help system and playing around with that for your Highlighting problem.

    John

    ps: Excell is Event Driven. Thus an event must occur to trigger your email. What event would you like to link it to? This will give people a better stab at posting you a reply.
    I dont want to link it to an event, i would ideally like it to check each time the document is opened.. is that possible?

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,039
    Follow John's advice and use Conditional Formatting to highlight your row or cell. In the Conditional Format try selecting formula and put this formula

    =$G$3< TODAY()

    Your email part will need VBA and a little more information from you
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  5. #5
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,039
    =$G$3< TODAY()
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  6. #6
    Join Date
    3rd February 2004
    Location
    Sydney
    Posts
    51
    Originally posted by royUK
    Follow John&#039;s advice and use Conditional Formatting to highlight your row or cell. In the Conditional Format try selecting formula and put this formula

    =$G$3<TODAY()

    Your email part will need VBA and a little more information from you
    Hi Roy,

    I tried that formula but nothing happened....

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,039
    Sorry the formula isn&#039;t copying properly it should have <TODAY() at the end.

    I have emailed an example
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  8. #8
    Join Date
    3rd February 2004
    Location
    Sydney
    Posts
    51
    Thanks for your help guys!

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    3rd February 2004
    Location
    Sydney
    Posts
    51
    sorry... im abit simple with excel.. im just a newbie... is there a quicker way to "fill down" the conditional formatting so that it will automatically change the formula for each line?

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,039
    If you have used the $ sign to fix your reference as in my example delete the $ from before the 3 and then drag it down, ie select the cell, hover the cursor on the bottom right corner of the cell until it turns to + then drag down.
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 1
    Last Post: May 6th, 2008, 21:07
  2. Highlight Cell If X Days Past Today
    By AJC_2007 in forum EXCEL HELP
    Replies: 7
    Last Post: August 11th, 2007, 05:50
  3. [Solved] Formulas: Nested If using today date
    By bearlover in forum EXCEL HELP
    Replies: 4
    Last Post: August 27th, 2003, 23:28
  4. Replies: 9
    Last Post: July 14th, 2003, 05:39

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
  •  
porno