+ Reply to Thread
Results 1 to 2 of 2

Can't highlight in the same column..conditional formatting

  1. #1
    Registered User
    Join Date
    07-01-2020
    Location
    Philippines
    MS-Off Ver
    Microsoft Excel 2013
    Posts
    1

    Can't highlight in the same column..conditional formatting

    I need help. I'm making a report on drivers monitoring. I already figure out how to highlight the driver name in the sheet 2 drivers list, when the driver is assign to drive in the sheet 1, I'm using the COUNTIF. The next process is remove the highlight when the driver is arrived, I'm using the ISODD. The drivers name and the arrival time are in the same column. The problem is when you input the driver's name in the next column with the same name, the name of the driver in the sheet 2 drivers list won't highlight again. What formula i will use to highlight it again?
    Thanks
    Attached Files Attached Files
    Last edited by ralcuin; 07-01-2020 at 09:54 PM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Can't highlight in the same column..conditional formatting

    In driver sheet, use only one CF to highlight driver name, in row 5 sheet vehicle, in condition of:
    Count number time occur of that driver accross multi columns, accross multi vehicle, to see ISODD or not.
    CF of B4 sheet driver:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Quang PT

+ 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] Conditional formatting: Highlight max value in a column. What's wrong with this?
    By darxide23 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-20-2020, 12:12 PM
  2. Conditional Formatting to Highlight Column done
    By Tinkas in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-07-2019, 10:51 AM
  3. Conditional Formatting to Highlight Dates in a Column
    By tatertot7 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-22-2019, 03:36 PM
  4. Conditional formatting to highlight a column
    By msexcelforgood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2019, 02:54 PM
  5. Using Conditional Formatting to Highlight a COLUMN Instead of a Row
    By clayshooter12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2017, 11:38 PM
  6. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  7. Replies: 5
    Last Post: 03-18-2011, 03:32 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