var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sorting/Extracting by cell color
Hi Guys !!!
Is it possible to have excel take data from a colored cell (or cells) and display it somewhere else?
I've been trying this for some time and I've had no success.
You can sort/filter by colour in Excel 2007 or later.
If there is an underlying logic as to how the cells are coloured (eg. conditional formatting) then that logic could be used to extract the required records.
Or use VBA in previous versions of Excel (in 2003 or earlier)
For example, the following code line only copies the value of cell A1 to cell B1 if the color of the value in cell A1 is red.
Hope this helps..
If Range("A1").Font.Color = vbRed Then Range("B1").Value = Range("A1").Value