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...