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.
You can't modify cells based on that cell or another cell's fill color. Fill colors are there for humans only to provide a visual result.
If your fill cells are filled a certain color based on a formula or some logic which you can implement then you can use conditinal formatting to a) apply a fill color to a cell in Col B and b) change the font color of a cell in Col A.
Say thanks, click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks