Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am looking for an easy way to sort a range by font color. The range is
made up of 14 columns and I want to sort by Col. 12. Col. 12 has empty cells, cells with font color index = 15 and cells with font color index = xlAutomatic. I want to delete all the rows that don't have a font color index = xlAutomatic in Col. 12. I currently have a loop that does this, but it takes a long time. I figure if I can sort all font color index = xlAutomatic to the top I can quickly delete everything underneath very easily. Is there a way to sort by font color? I know you can do it in 2007, but what about 2003? -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort by font color with Excel | Excel Discussion (Misc queries) | |||
How do I sort a column of different font colors by color? | Excel Worksheet Functions | |||
Extracting font color within a range | Excel Programming | |||
Sort or sub-total by Fill color or font color | Excel Discussion (Misc queries) | |||
Can you sort Excel data by font color? | Excel Discussion (Misc queries) |