VBA Conditional formatting to delete entire row when two variable are ture

Hi all,

In my on-going work project (that i thought was finished ><) I have code that basically does this:

IF cell1 = cell2 THEN highlight entire row Blue.
IF cell3 = cell4 THEN highlight entire row Red.

This obviously cause problems when both are true as the as the you can't see both colours.

Is it possible to have something to the effect of:

IF cell1=cell2 AND cell3=cell4 THEN delete entire row.

I have tried a few variations that sound intuitive, but I cant seem to get the code syntax right.

Thanks for any help you can give me, much appreciated!

ADTC.

Originally Posted by Mordred

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

my apologies, thanks for the reminder.

thanks again in advance to anyone that can help me with this coding.

Hi SOS,

Thanks for working out the re-wite for me. I have just given it a go but it doen't quite work.
The formatting works perfectly, it's just the loop for deleting the rows where [cel1= cell2 AND cell3=cell4].

At present, it looks like it is only deleting the very first row, from the bottom, where cell1=cell2 which it should not delete as it does not satisfy the criteria for deletion: [cel1= cell2 AND cell3=cell4].
After it deleted that first row, the loop/macro stops.

Hope this helps .
And thanks again for going to the trouble of helping my get this working.
I can send you a mock workbook if you need.

ADTC.

I've uploaded to mock workbooks.

One with VB code already in (for reference if needed)
http://dl.dropbox.com/u/8139608/VBmock.xls
And a second with No VB code if you like a clean slate, but need to see how it should look.
http://dl.dropbox.com/u/8139608/NO-VBmockmock.xls

Hope this helps
Thanks for all your hard work.
I look forward to seeing what you come-up with if you have some free time

ADTC