I have a list of NBA Players in Column A with a list of Yes, No and Maybe in Column I. Based on what Column I lists, the color and fill changes to Green, Red and Yellow using conditional formatting. How do I copy the colors from Column I to Column A, with column A changing as Column I changes?
Bookmarks