So, I have a billing spreadsheet with a list of names in column E. I have pay columns that are based on years of experience. The names in Column E contain an * if they are first year and ** if they are 2nd year. What I want to do is change the background colors depending on * or **. I've tried with conditional formatting but what I've tried isn't working. So, if cell E5 has a name: last name, first name (*) then I want cell H5 to turn blue. Can conditional formatting do this alone or do I need a formula to assist? Thanks in advance.