Results 1 to 5 of 5

Conditional Formating to highlight cell (text word) if not included in a table of words

Threaded View

  1. #1
    Registered User
    Join Date
    09-27-2019
    Location
    Dublin
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    22

    Conditional Formating to highlight cell (text word) if not included in a table of words

    Hi,

    Is there a way to set conditional formatting to highlight cells if the word/name is not included in a list.

    I have a complex table that gets filled out by a lot of different people in bulk via copy and past.
    The data is set up via data validation dropdown list, however due to volume this is not used. (e.g. some people will need to complete 12 columns x 500 rows each day).

    The people inputting information are responsible for ensuring the data matches set criteria, otherwise when I consolidate and try to upload it spits out errors.
    Errors can result from as little as an added space, misspelling, or something completely invalid.

    They do try to review, however again due to volume it is hard to pick out a minor error.
    My idea is if it highlights the cell due to it not being in the list, then they can filter for colour and correct.

    An added complexity is our IT security systems don't allow VBA's on our laptops.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 08-03-2016, 06:18 PM
  2. [SOLVED] Index Match with Text included but can't change formating?
    By Excel15 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-16-2015, 12:06 PM
  3. Replies: 5
    Last Post: 03-03-2015, 03:20 PM
  4. Need to use conditional formating to highlight a cell
    By Paul Ak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2014, 01:06 PM
  5. Conditional formating highlight cells in column Q that have certain word in it
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-30-2011, 02:26 PM
  6. Replies: 3
    Last Post: 08-28-2009, 11:16 AM
  7. Word Formating & Words Adding
    By Kelvin Lee in forum Excel General
    Replies: 1
    Last Post: 11-28-2005, 12:33 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