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.![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
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.
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
![rKs8mWI.png](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FrKs8mWI.png&hash=4c38b503eef4a6616a60ffad042221cc)