VBA to identify files has No highlighted in Green in particular column

Hi,

Is there any VBA code that can help me Identify if files has no highlighted in Grean in Particular Column which is in Column B row 1 only. Because I have a hundreds of files to open each to validate if each files has green highlighted.

It is possible to create a checkfile on which files doesn't have a green Highlighted.
For example a created checkfile has a column "Filename of the file on which don't have a green highlighted" just a file name of it.


Hope you can help me with this. thanks in advance.

I have attached a 2 sample files (Sample 1 has a greenhighted and sample 2 doesn't have green highlighted), in this case the macro will create a file and has a column which tells you on what filename of the file doesn't have a green hightlighted.


Thanks again!

Should you search all sheets in each workbook or just the first one?

Artik

Only in first Sheet. Some files has different sheet name but we need to check only the first sheet in the file.

Try:

Please Login or Register  to view this content.

Artik

This is perfect! however it is possible to open all the files from the main folder and well as with the sub folder. Because of the files are in the main folder but also has a sub folder?

Hope this is possible.

You are my lifesaver! thanks in advance again!

Try this:

Please Login or Register  to view this content.

Artik

THank you so much! this is perfect!