VBScript to change color of target if range color is same

Hello all,

I am in a bit of a pinch. I have created a spreadsheet in which a minimum and maximum tolerance is established off of an entered value and is displayed on each side of said value (IE - C9 = Min, D9 = Entered Value, E9 = Max).

I have also added conditional formatting so when the min and max are identified, it will automatically color the entered value cell green if it is within limits, or red if it is not.

My Question is that I have several sets of data (17 to be exact) and I would like to make a script to automatically check or color a separate cell if all of the entered value cells turn green and fall within the limits, or check a different cell if there is one or more cells that is red.

Unfortunately I am completely lost with this and I don't know where to start. Any help would be appreciated.

Thanks!

-Matt

First off, I meant VBA. Secondly if there is any way to do this with conditional formatting I would love to know.

I have attached a sample of what I am talking about. Unfortunately I can't attach the actual file as it is sensitive information.

I would like to know how to get the "Unit Accept" box to either be colored in, or have a "x" put in it if all the Actuals are green. If one or more of the actuals are red, I would like the same thing to happen, but in the "Unit Reject" Box.

Ahhh great, thanks for the help. Instead of basing it off the colors I should have just done that to begin with!

Thanks,

-Matt