+ Reply to Thread
Results 1 to 2 of 2

Proper use of table references in Conditional Formatting

  1. #1
    Registered User
    Join Date
    11-07-2017
    Location
    Binghamton, NY
    MS-Off Ver
    2016
    Posts
    15

    Question Proper use of table references in Conditional Formatting

    Is there any way to use a table reference (e.g. Table1[Fieldname]) in a Conditional Formatting formula? I'm thinking here about the workarounds for referencing tables in Data Validation using the Indirect function, and wonder if there might be a trick to outsmarting Excel Conditional Formatting. I realize, of course, that I could use direct cell referencing if there were no other option.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Proper use of table references in Conditional Formatting

    Define a name, point it at the table column, then refer to that name in the CF formula.
    Rory

+ 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. Replies: 2
    Last Post: 11-21-2017, 12:34 PM
  2. [SOLVED] Conditional Formatting with different references
    By emmieshane in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-07-2017, 04:18 PM
  3. Conditional formatting - Relative references (2010)
    By banks334 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2015, 01:44 PM
  4. [SOLVED] Proper way to apply conditional formatting to new entries of data.
    By Melvinrobb in forum Excel General
    Replies: 6
    Last Post: 07-09-2012, 03:08 PM
  5. Excel 2007 : Conditional Formatting Cell References
    By HangMan in forum Excel General
    Replies: 1
    Last Post: 03-21-2012, 01:23 PM
  6. Conditional Formatting - Proper Names
    By Skoal in forum Excel General
    Replies: 3
    Last Post: 09-01-2006, 03:00 PM
  7. [SOLVED] Conditional formatting-Can I not use references to cells
    By Big Boss in forum Excel General
    Replies: 3
    Last Post: 08-11-2005, 08:05 AM

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