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

[Philipluis30]

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!