Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format to Delete Row
I have a conditional format that turns the cell red if today date is 45 days
greater thatn the date in the cell. If the cell is red, how can I delete the entire row automatically? -- TC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format to Delete Row
Assume the date is held in column F
Dim lastRow as Long, i as Long lastrow = cells(rows.count,"F").End(xlup).row for i = lastrow to 2 step -1 if clng(Date) clng(cells(lastrow,"F").Value2) + 45 then rows(i).Delete end if Next so check the condition. It is extremely difficult to check the color of a cell colored by conditional formatting. -- Regards, Tom Ogilvy "Teresa C" wrote in message ... I have a conditional format that turns the cell red if today date is 45 days greater thatn the date in the cell. If the cell is red, how can I delete the entire row automatically? -- TC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Conditional Delete | New Users to Excel | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |