Announcement

Collapse
No announcement yet.

[Solved] If value is before today highlight line red

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Solved] If value is before today highlight line red

    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?....

  • #2
    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.

    Comment


    • #3
      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?

      Comment


      • #4
        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

        New users should read the Forum Rules before posting

        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.

        Comment


        • #5
          =$G$3< TODAY()
          Hope that Helps

          Roy

          New users should read the Forum Rules before posting

          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.

          Comment


          • #6
            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....

            Comment


            • #7
              Sorry the formula isn&#039;t copying properly it should have <TODAY() at the end.

              I have emailed an example
              Hope that Helps

              Roy

              New users should read the Forum Rules before posting

              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.

              Comment


              • #8
                Thanks for your help guys!

                Comment


                • #9
                  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?

                  Comment


                  • #10
                    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

                    New users should read the Forum Rules before posting

                    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.

                    Comment


                    • #11
                      Originally posted by royUK
                      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.
                      Sorry, im not following....

                      Comment


                      • #12
                        Did you use the formula that I emailed to you,

                        =$G$3 etc

                        Replace this part with

                        =$G3 then you will be able to select the cell/range and drag it down. Hover your curser over the selection and move it towrds the bottom right. A drag handle in the shape of a + will appear.
                        Hope that Helps

                        Roy

                        New users should read the Forum Rules before posting

                        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.

                        Comment


                        • #13
                          Roy,

                          I have edited your post formulas so they should now show OK, albeit with a space btwn < and TODAY

                          I only discovered this the other day. The board interprest < as an HTML character so you have to add a space after it otherwise everything following it disappears...

                          Hope this helps
                          Kind Regards, Will Riley

                          LinkedIn: Will Riley

                          Comment


                          • #14
                            Thanks again for your help guys... now i just need to sort out the email thing!

                            Comment


                            • #15
                              Thanks Will
                              Hope that Helps

                              Roy

                              New users should read the Forum Rules before posting

                              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.

                              Comment

                              Working...
                              X