Pull values from conditionally formatted cells - Excel 2013
Closed
rohan.gupta23
Posts
2
Registration date
Tuesday July 9, 2013
Status
Member
Last seen
July 11, 2013
-
Jul 9, 2013 at 10:02 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 12, 2013 at 12:12 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 12, 2013 at 12:12 AM
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
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
Related:
- Pull values from conditionally formatted cells - Excel 2013
- Microsoft office 2013 free download - Download - Office suites
- Office 2013 requirements - Guide
- Marksheet format in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to change date format in excel - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 11, 2013 at 02:00 AM
Jul 11, 2013 at 02:00 AM
if your version of excel is 2007 or latter then you can filter according to color and copy the filtered data to aother location
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 12, 2013 at 12:12 AM
Jul 12, 2013 at 12:12 AM
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
Jul 11, 2013 at 07:53 AM