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
Bookmarks