Is there anyway to filter a column instead by the information that's in the cell and rather by the color of the cell ?
Like if column B has some of the cell background as red, how do I filter for that by color ?
Or maybe a formula that will copy the contents of cells with red color into a different column ? like Autofilter by color maybe ?
Please let me know, maybe there is some simple VBA code that will look at column B and copy maybe all rows that have red color in column B.
Thanks!!!
Like if column B has some of the cell background as red, how do I filter for that by color ?
Or maybe a formula that will copy the contents of cells with red color into a different column ? like Autofilter by color maybe ?
Please let me know, maybe there is some simple VBA code that will look at column B and copy maybe all rows that have red color in column B.
Thanks!!!