Filter Col B on Aud
Select Col A
Press F5, click SPECIAL
Select VISIBLE CELLS only
Color the cells

"Donna" wrote:

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