I have a large master worksheet with colums like this:
Account #, Name, Address, Status
I also have a list with Account # and the word "Paid" representing their status.
I need to highlight the Account # in the master in Blue if the status is paid. How can I do this?