Thread: Formula and Conditional Formatting for Cell Color & Data Pull

Good Afternoon.

I need help color coding cells based off of another cells color and data within the cell.

I will try to explain it the best I can and also post a few attempts at the code I used.

Columns E & M Have data in them that can be similar - here is the formula that I need.

If the data in E is the same as the data in M and the background color of E is orange then the background color in M needs to be orange. (Data must be exact match - IE. Johns isn't the same as St. Johns)

If the data in E is the same as the data in M but the background color in E is blank or white then the background color in M needs to be yellow.

If the cell in M is yellow or orange then the cell adjacent in Column N needs to equal the same cell color. (This can be a separate formula)

We tried using a code similar to =IF(AND(E:E=M:M,E:E ="Orange"), "Orange", "Yellow") but replaced the colors with various ColorIndex codes to no avail.

I've attached a document with notes to explain what the file should look like.

Any help would be greatly appreciated.

Thank You Very Much.

Aaron