+ Reply to Thread
Results 1 to 2 of 2

Highlight row with two conditional - worksheet is link to access query

  1. #1
    Registered User
    Join Date
    05-25-2012
    Location
    Virginia beach, Virginia
    MS-Off Ver
    Excel 2007
    Posts
    57

    Highlight row with two conditional - worksheet is link to access query

    I have a link excel worksheet from access database query which the information on the worksheet is refresh daily. I would like to have the rows highlighted in yellow when the below conditions meet:

    column H has 30 NET
    column Z has TVLS PROGRAM.

    The name on the worksheet is UPS - No Date. I have tried the conditional formatting but it only highlight when I click on the cell.

    Is it possible to have this task complete on refresh or do I have to have macro?

    I have attach an example (removed connections)
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Highlight row with two conditional - worksheet is link to access query

    Hi,

    Use the Conditional Format

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and apply it to the whole of A2:Znn
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Access Query/SQL display table code descriptions for multiple codes
    By WBravard in forum Access Tables & Databases
    Replies: 1
    Last Post: 02-04-2018, 07:40 AM
  2. Dynamic link to Access query for updating Excel table
    By BanginMyHeadOnMyDesk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2017, 11:45 AM
  3. [SOLVED] Query problem in access to link two tables
    By sohel_for in forum Access Tables & Databases
    Replies: 2
    Last Post: 12-12-2015, 09:58 PM
  4. Problems with Excel link to Access query not updating
    By JayhawkPammy in forum Excel General
    Replies: 3
    Last Post: 12-06-2013, 10:05 AM
  5. Removing Link to Access Query
    By a_ryan1972 in forum Excel General
    Replies: 0
    Last Post: 04-11-2005, 01:06 PM
  6. Link Access table to Excel worksheet
    By dalesrunner in forum Excel General
    Replies: 1
    Last Post: 03-27-2005, 08:06 PM
  7. [SOLVED] Link Access query to refresh an EXCEL file
    By Dancer4u in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-13-2005, 02: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