Like the title states I am looking for a means to find all rows that have a colored cell. My clients do not maintain any one color when setting a cell background. I am working in Excel 2007 and am aware of the sort columns by color and also have played with some VB to look at individual colors per column, but I was asked to find a means to sort all records to find ANY row with a cell that has a color.
Thanks
Hi,
How about this function as a starting point?
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Easiest way is to use a helper column and a udf like this and then sort on that:
Note that the you would need to force a sheet recalc for the formula to re-evaluate any coloured that were added/removed.Please Login or Register to view this content.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks