I am trying to write some code that will check if Column Y="N" and if it does it will check Column R, O, G and if there is no color index in any of the Columns the macro will delete the row.

Column Y-has Y, N entered in cells
Column R-has 1,2, etc... entered in cells ( some cells have color index 26 ) Color set by Conditional Format
Column O-has 1, 2, etc... entered in cells ( some cells have color index 3 ) Color Set By Format
Column G-has names entered entered in cells ( some cells have color index 38 ) Color set by Conditional Format

There are 3000 rows on the spreadsheet and the macro would need to loop through all the rows. Any help would be appreciated.