joeyc
11-02-2008, 12:57 AM
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.
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.