Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wrote a macro to turn the interior color of a cell green if the value is
changed. I am sent a worksheet with several hundred rows (no fixed # of rows) and I need to deal with the green cells. Excel 2007 lets you sort by color only for one column. I want to have a macro look at the cell color from A:AK for each row in the worksheet and if any cell is green to sort the row to the top (or filter it to only show cells with green). If the reen 'rows' could be sorted by column A that would really be fantastic but not a requirement. I have a manual work around and have tried some VBA myself but this is over my head. Anyone know how to accomplish this? -- Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ColorIndex vs Color? | Excel Programming | |||
tab.colorindex linked to cell color | Excel Worksheet Functions | |||
ColorIndex returns incorrect color | Excel Programming | |||
Name of color for a particular colorindex number | Excel Programming | |||
need to set a cell background color which is not within the Excel colorindex range | Excel Programming |