How can I format Column A to change colors if the corresponding line in
Column B equals "Aud". I then need to delete the reference Column B and have
the colors in Column A remain after I delete column B. Thanks Donna