Results 1 to 4 of 4

Trying to use conditional formatting to color cells that match list on other spreadsheet

Threaded View

  1. #1
    Registered User
    Join Date
    01-26-2021
    Location
    New Jersey, USA
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    5

    Trying to use conditional formatting to color cells that match list on other spreadsheet

    I'm trying to figure out how to get this spreadsheet to highlight drugs on an invoice that match a certain list. I need each class of medication to highlight differently on the main sheet, ex: blood drugs have a red background, chemo have a purple, etc.

    To better explain, the first sheet is called "Paste Invoice Here". The user will download invoices as a CSV and paste the entire invoice in field A1. I want fields J17-J82 to look for matches on the sheet "Sorting Data", and highlight with the appropriate color. The drugs have different forms, which is why I have asterisks on the words. Basically I want "Paste Invoice Here" to reflect the color on "sorting data" so she can see which of each class of med is on the invoice after she pasts it, if this is applicable. If not my goal is to move the information to that cell into a list below each class of medication on the "results" page.

    I have a copy of my excel attached, and thank you so much everyone for the help on this site
    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. Drop Down List Color Selector - NOT Conditional Formatting
    By airj1012 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2020, 05:32 PM
  2. Replies: 2
    Last Post: 04-08-2020, 05:30 PM
  3. Conditional Formatting - Color Formatting for Blank Cells
    By mlbdc2012 in forum Excel General
    Replies: 10
    Last Post: 02-10-2015, 06:28 AM
  4. Replies: 3
    Last Post: 05-30-2014, 10:24 AM
  5. [SOLVED] Conditional formatting color 3 numbers in another list
    By Berna11 in forum Excel General
    Replies: 5
    Last Post: 03-08-2013, 12:19 PM
  6. Pattern Search Of Conditional Formatting Color in Spreadsheet
    By ssjagger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2013, 12:38 PM
  7. Conditional formatting: No background color when list item is selected
    By earthtodan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2008, 09:18 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