Hi, I need help developing a macro that can do a couple different things.

Situation: Someone else maintains a project spreadsheet in which projects (rows) are frequently added or removed; projects are tracked by number in column A. I download this spreadsheet regularly to work from the newest iteration and track work on the projects. I want to highlight rows for which projects that have been started (let's say in green) and projects that have been finished (lets say dark blue).

Macro: The only way to consistently track the projects is by project number, as line numbers change with iterations. So I was thinking of using a macro where I could set conditional formatting based on whether the line includes a specified project number. I could update this macro by adding new numbers in the conditions when needed, and run the macro in the new iteration of the workbook.

For example, if the cell in column A = {"1","3",1094"} then the row will be green, OR if the cell in column A = {"2","10","82"} then the row will be dark blue. If I start project 4, then I will edit the macro and add "4" to the "green condition" or if I complete project 1094, I will move "1094" to the "blue" condition; then save the macro.

I tried making one myself, but could only hide (not colour) rows based on one (not multiple) values. Can anyone help me develop a macro for this?

Thank you.