MrExcel Publishing
Your One Stop for Excel Tips & Solutions

conditional format - delete row


Posted by Ren on December 27, 2001 12:54 PM

If there is a "0" in column V, delete the entire row.

Can someone please rewrite this in correct form?


Posted by Kevin Mac on December 27, 2001 1:04 PM

Ren,

Where are you from????

Posted by Ren on December 27, 2001 1:08 PM


WHY? Can you help me? : If there is a "0" in column V, delete the entire row.


Posted by Kevin Mac on December 27, 2001 1:15 PM

WHY? Can you help me? :

The easiest way I know of to do it is to record a Macro to do it for you. I personally do not know of a way to use Conditional formatting to delete rows if the condition is true. However, I was just curious if I know you or not.

Posted by Ren on December 27, 2001 1:37 PM

Grew up in Northern California
I went to college in San Diego
I live in Houston now.
Where are you from?