Conditional formatting and data validation with VBA macro

[JantjeB]

I'm making an excel sheet to keep track of software version numbers and want to be able to see outdated software versions.
Different software packages are written in rows, the columns contain pieces of the software.
One of the things I want to do is create conditional formatting for the different columns to check whether the used version is the latest version (the different versions are in a names list). This has to be done for the different columns.

Since I am quite new to VBA programming, I can't seem to get this done. The following code is used to retrieve all worksheet names, make a list of available version numbers and apply data validation on the first worksheet "Overview".

After this is done, I want to apply conditional formatting to make the cells have a lower value than the maximum value in the corresponding list. The problem I'm experiencing is the fact that I'm not sure how to check different lists for different collumns. Am I going the right way, or doesn't this make sense at all? Right now, some cells to the right of an "outdated" cell are colored red too.

Please Login or Register  to view this content.