I have a worksheet with a table that records payments with prepaid debit cards for my company. In this table, there is a new entry for each purchase, so people will be entered in the table. Since the table is sorted by the people's names, I want rows to automatically highlight a certain color according to the person's name every time a new entry is created. There is about 13 people who could possibly show up on this list, so I wasn't sure that I could do it just with conditional formatting (although if know a way to do it with that, I would love to hear it). Capture.PNG
Thanks for helping me out with this, I appreciate it.
Bookmarks