Compare three cells and delete row

I am trying to write some code that will compare three cells on a row and if they match then it will delete the row.

Column U-has Y, N entered
Column V-has Y, N entered
Column O-has 1, 2, entered (some cells may have the fill color set to red)

I need the macro to look at Column U and Column V and for example if the cell U2 has a N, and V2 has a Y then the macro would look at O2 and it there is a 1 with the fill color set to red the macro will delete that row.
The spreadsheet will vary on how many rows it contains. It can contain up to 5,000 rows and the macro would need to go through all the rows.
Any help would be greatly appreciated. Thanks

do they have to be deleted or can they be hiden?

Deleted if possible

How about if Column U and Column V and for example if the cell U2 has a N, and V2 has a Y and it would delete the row unless O2 has a 1 in it with the fill color set to red then the macro would not delete that row?

sorry, i dont quite fully understand what you mean

Just to clarify...

Column U-has Y, N entered
Column V-has Y, N entered
Column O-has 1, 2, entered (some cells may have the fill color set to red)

For example if the cell U2 has a N in the cell, and V2 has a Y in the cell then the macro would delete the row unless O2 has a 1 in the cell with the fill color set to red then it would not delete the row. If O2 has a 1 in the cell with no fill color then the macro would delete the row.
The spreadsheet will vary on how many rows it contains. It can contain up to 5,000 rows and the macro would need to go through all the rows.

oh ok sorry, im being a bit thick today.

try this,

Please Login or Register  to view this content.

this says if col u value = N and col v value = Y and O value = 1 and o fill color isnt red then delete

No problem, glad to help