Hello, I am working on a project in Excel:

My plan is to fix a simulation in excel and then create an
image of a vessel which is build out of blue lines stapled on each
other. With VBA want link the lines with values in
the excel sheet which turns the blue lines transparant. That way it
looks like the vessel is
emptying. I guess I also have to put in a time delay or some kind
between execution of the code.

So far the simulation is done, except the vba part. Therefore my
question is how I begin to fix this, and is it even possible? I am a
little bit familiar with VBA. Is there some simple way to change the
properties of these lines?

Sketch:

___________________ Blue lines. if a value becomes below the level of
this it should turn transparant.
___________________
___________________
___________________
___________________
___________________

If there is anyone with ideas, I am open for suggestions.