I am attempting to pull the cell next to highlighted cells (cells I have highlighted via conditional formatting) into a list on another sheet. Is this possible?
Basically, I have asked conditional formatting to highlight the top 5 numeric values in a column. Next to that column in a text description. I want to pull the top 5 to another page and only list the text description. I'm wondering if there is an IF formula or some other way to look for the highlighted fields and pull the corresponding text.