I have two columns. The first one (A)contains text adjacent to the colored cells the second column (B) contains cells that have different Fill colors. . I am trying to change the color of the text in the FIRST column (A) to the corresponding color in the adjacent cell in the SECOND column (B). I don't think conditional formating works well in this situation. I believe the solution would be some sort of macro.
Thanks for your help.
Bookmarks