Value Insert based on Existing Value sharing same cell color

[lotusblossom]

Hello,

I have several rows that share the same background color. I'm working with an array. I want to perform a search that will identify a value then assign a new value to it. That new value would be inserted into a new column. The column search would only extend to cells that have the same color.

1) Search column based on cell color
2) Assign a new value to value in the column
3) Insert the new value into a new column

For Each ws In ActiveWorkbook.Worksheets
For Each e In Array(Array("Bird", "ECNOT"), Array("Car", "ECOOR"))


Thank you very much.