+ Reply to Thread
Results 1 to 5 of 5

rows left count

  1. #1
    Registered User
    Join Date
    10-20-2012
    Location
    hong kong
    MS-Off Ver
    Excel 2007
    Posts
    84

    rows left count

    Hi, expects
    I want to checked cells by row to left…let say Start from range E3 to left ( not sure the last column since day records number of the rows)
    If E3 > H3 then H3 pattern yellow
    If H3 > J3 then J3 pattern yellow
    If J3 > L3 then pattern yellow ….. So on
    Next start From E4 …

    How to build the module code? Kindly giving hints or help?

    I really don’t know how to do it exactly.

    Please help

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,619

    Re: rows left count

    Quote Originally Posted by ks1102 View Post
    ….. So on
    There is no "So on"
    E3 vs H3 : 3 columns difference
    H3 vs J3 and J3 vs L3 : 2 columns difference

    basically construction like
    Please Login or Register  to view this content.
    shall work for you

  3. #3
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: rows left count

    It's difficult to follow, as there is no clear pattern.

    Have you tried Conditional Formatting?

    Please remember, your request is clearer if you attach a sample workbook.
    - Click on Go Advanced and click on the Paper Clip.
    When you reply please make it clear WHO you are responding to by mentioning their name.
    If this has been of assistance, please advise. A little thanks goes a long way.
    - Please click on the *Add Reputation button at the bottom of helpful responses.
    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

  4. #4
    Registered User
    Join Date
    10-20-2012
    Location
    hong kong
    MS-Off Ver
    Excel 2007
    Posts
    84

    Re: rows left count

    Thanks all the reply and suggested, i knowing it's might difficulty but any way thanks

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: rows left count

    Maybe:

    Please Login or Register  to view this content.

+ 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. Count using left function in Range
    By vinaynaran in forum Excel General
    Replies: 2
    Last Post: 07-27-2011, 11:38 AM
  2. Replies: 2
    Last Post: 03-30-2010, 12:41 PM
  3. Count if numbers in cell to left
    By Nadir Soofi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2008, 09:22 PM
  4. Limit character count in cell from left
    By BMF in forum Excel General
    Replies: 5
    Last Post: 07-12-2006, 01:11 PM
  5. Count-down timer? (e.g. 10 days left...9...8...)
    By mesotech in forum Excel General
    Replies: 3
    Last Post: 01-06-2005, 01:06 PM

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