Change Cell value based on cell color

[glewin1]

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

[zbor]

Can you upload example workbook?

[glewin1]

Sure. Please see the attached file. I changed the color to green in this example, but any color will work. Thanks.

Greg