Error Checking Macro to cycle through rows looking at specific columns for things

Hi Guys,

I'm not really sure of the best way to do this, but I'm trying to make an error checking macro to find and highlight errors within my sheet.

I need it to cycle through rows (4 to last row) and if there is any content in that row (from B:Z) ignoring formulas for it to check the following:

1) Check Column G has an @ symbol somewhere in it, if it doesn't then put a red background on that cell.
2) Check Column D for a value, if there isn't one then put a red background on that cell. (Do the same for Column F)
3) Check that the formula in J doesn't return #N/A, if it does, then color the cell 1 to the left with a red background. (In my example I've used #VALUE! for the example)

In my real sheet there are 25-50 "REQUIRED COLUMN"s and 5~ columns with formulas that need to be checked, some are coloring the cell to the left, some are coloring the cell to the right some are coloring a cell 10 to the right.

If you look at my example, it would essentially turn MAIN into what AfterExample looks like.

I would greatly appreciate some help with this.

Hi there,

Try the following code and see if it does what you need:

Please Login or Register  to view this content.

You can change the highlighted values to suit your own worksheet requirements.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Maybe:

Please Login or Register  to view this content.

Hi again,

Many thanks for the Reputation increase - very pleased that I was able to help

Best regards,

Greg M