Hello,
I am trying to change the values of one column of cells, based on the color of a second column of cells.
I would like Column B to change it's value from N to E if the adjacent cell in Column A is formatted Orange otherwise leave the value as is. I have already formatted column A so that the cells I need colored Orange are changed already. I am using Office 2010 if this is relevant. Thanks in advance for your help.
Greg
Bookmarks