(And) If-Then Statements

[Vkrage]

I am looking for VBA script to do the following:

If E3 says Slnt and G3 says 200, then I want G3 to still say 200, but be highlighted blue and if it is not 200 then I want it to say nothing.

I would like to do this from E3:E300 and G3:G300.

Is this possible? I have many options for Slnt, W, Etc. and they all need to be seperated by color according to the number represented in G. For example, if E3 says Slnt and G3 says 460, then I want it purple.

[inq80]

Should be:

something like this should get you started:

Please Login or Register  to view this content.

You'll need to set a variable though for the rows to loop through and reference it within your loop statement.

[Vkrage]

How did I set the variable for the rows to loop through and reference?

[inq80]

Does this help?

Please Login or Register  to view this content.