Okay, so I have this data and its a bunch of different categories and each line item has notes with it in a separate cell as text. The entire spreadsheet is replaced everyday but many of the same items exist.

I know I can make a separate worksheet, put the notes on that spreadsheet and VLookup them to a specific combination of Account number and Transaction date. So that Note A autofills in the line with the account number "XYZ" and Transaction Date "X/Y/ZZZZ". (Any help on the VLookup Formula bring it on! We are talking about thousands of lines or I'd just if statement it) But I'd also like for that cell to autofill with a specific color. So at a glance someone could see that "Oh this is a green note, this means X" without having to necessarily read the detail. I imagine it maybe could be done with something like =if(Cell)="text" color Blue but I don't know how to get something to color that way or if its even possible. Thank you so much!