-
sort by font color
Hi,
By any chance does anyone have a macro lying around that would sort columns by font color?
I have applied conditional formatting to a few rows on a large worksheet. The cells of interest to me are bold and in red. It would be very convenient if these rows would appear on top so that I wouldn't have to scroll through a large spreadsheet and find red colored words.
I have attached an example.
-
Check out this site for some good info
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
thanks
I will read up on this one. Give me one day.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules