+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting adjacent cell

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2013 Office 365
    Posts
    9

    Conditional formatting adjacent cell

    This workbook contains several thousand rows of data to track asset numbers being used each day, the driver who drives that asset and the starting and ending mileage for that work day. The starting and ending mileage is entered from daily log sheets submitted by each driver at the end of his /her shift. A common problem with this strategy is Sally is careful to note each starting mileage before she actually leaves the yard; whereas, Steve starts his logbook two hours at a rest break and estimates his starting mileage for the day. I am trying to keep track and maintain good data on starting and ending mileage; if 20600 is used on 2/1/2015 and has a starting ending mileage of 1, 2; then tomorrow's starting mileage for that same asset should start with 2.

    Conditional formatting works using this formula =D5<>OFFSET(D5,-1,1); however, it does not take into account changes in column A when the asset changes on a new row of data even after sorting by asset, date and starting mileage. If the asset changes on a different day or the same day for that matter conditional formatting will highlight the cell in column D if the adjacent cell data is different in column E.

    Is vlookup necessary in this instance? Do I need to consider other options?
    Attached Files Attached Files
    --
    Keith Bell
    dkbell@gmail.com

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,998

    Re: Conditional formatting adjacent cell

    Take a look at this.
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ 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. [SOLVED] adjacent cell conditional formatting
    By IronCladRooster in forum Excel General
    Replies: 3
    Last Post: 08-07-2014, 10:08 AM
  2. Conditional formatting on adjacent cell
    By branred in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2013, 03:40 AM
  3. Conditional Formatting based on Adjacent Cell
    By MacroPolo in forum Excel General
    Replies: 3
    Last Post: 06-23-2012, 01:41 AM
  4. Conditional Formatting Based on Adjacent Cell
    By Yourgurlwantsme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2010, 05:31 PM
  5. Replies: 2
    Last Post: 01-10-2005, 06:06 PM

Tags for this Thread

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