Pull values from conditionally formatted cells - Excel 2013

Closed
Report
Posts
2
Registration date
Tuesday July 9, 2013
Status
Member
Last seen
July 11, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
hello,

I have a large data set wherein I am trying to figure out where certain values fall and am applying a cell color using conditional formatting (CF). However, there the values appear in 20 contiguous columns but are unique for every row. Is there a way to pull these values based on color? I have read many posts regarding getting the color of a CF cell (the famous Chip Pearson one as well, http://www.cpearson.com/excel/CFColors.htm). However, I haven't found how to address the same in Excel 2013.
Any help would be appreciated!

Regards,
RG

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
if your version of excel is 2007 or latter then you can filter according to color and copy the filtered data to aother location
0
Posts
2
Registration date
Tuesday July 9, 2013
Status
Member
Last seen
July 11, 2013

Thank you venkat1926. I had been doing exactly what you suggested but the number of columns which were conditionally formatted grew from 6 to 20, and it is tedious to filter 20 columns one by one to get the values. I had read that there is a way to get the color of a conditionally formatted cell, however that code is not working in Excel 2013.
0
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
normally macro written for earlier version works for latter version. did you try that macro I hope you knowhow to copy the maro in a module
0