I am very new with excel and I am putting together a worksheet that has a
column consisting of two primary names. I would like to format the entire
column with the result being both names having their own color throughout the
column. Alternatively, I could go to each row and highlight the name but
there are about 1000 rows.

Thanks,
Aaron