This is my first post so I apologize if I am breaking any protocols. If it makes any difference, I have only been learning/playing around with VBA for about 2 weeks so everything that is in my code is what I have picked up from examples.

I am attempting to use VBA to apply conditional formatting to a certain range based on the value in a different column. My selected range has dollar values, and the other range has a percentage variance from the approved budget. So if the percentage is > 0% and < 10% I want to use RGB (255,192,0) and if the percentage is >= 10% I want to use RGB(255,0,0). So far I have been able to select my desired range and to find the relative reference between the two columns. I seem to be stuck on the conditional format statement(s).

Thanks in advance for any and all replies.

Please Login or Register  to view this content.