ExcelSammie
New Member
- Joined
- Jul 3, 2018
- Messages
- 3
Hello, I am new here. I am trying to extract the cell value based on the cell color within a row range. I have looked around and haven't found anything that has worked for me.
So I am trying to lookup between B2:Q2 the cells that are colored magenta and then return the cell value of the magenta cell into S2. I need to do this for thousands of rows.
So I am trying to lookup between B2:Q2 the cells that are colored magenta and then return the cell value of the magenta cell into S2. I need to do this for thousands of rows.

