I already have conditional formating set up on my spreadsheet whereby if column "M" states "Bound" then the text in the entire row goes blue and if it states "Lapsed" then it goes Red.

On the same sheet, I have a drop down box containing 4 names. Is it possible to change the background of each row depending on the name? Is there an alternative to conditional formating? I also only want the rows A-Z to change colour is this possible?